Hello, Is it possible to import csv file with different field names?? I want to have different field names in my table but want to import fields from csv in fields from table (I know which field to import in which field) thx juvi
Trying to understand what you need - it's vague. If you want to run a regular unattended import don't do it without the header row. After you import the csv file, run an append query to move the generic field name to the whatever field in the table you want. If you are doing it attended from the File Menu, just don't select First Row Contains Colum Headings. Bonnie http://www.dataplus-svc.com juvi wrote: >Hello, > >Is it possible to import csv file with different field names?? I want to >have different field names in my table but want to import fields from csv in >fields from table (I know which field to import in which field) > >thx > >juvi -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-modules/200806/1
Sure, just set up an import specification. File - Get External Data - Import, pick your file, but then click on the <Advanced> button. It'll then let you set your delimiters, specify YOUR name for each field, specify the field type for each field, specify fields to be ignored and not imported, and so on. Once it's set up save it and it'll be applied to that file forevermore. "juvi" wrote: > Hello, > > Is it possible to import csv file with different field names?? I want to > have different field names in my table but want to import fields from csv in > fields from table (I know which field to import in which field) > > thx > > juvi
