Possible to import csv file with different field name??

J

juvi

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
 
B

bhicks11 via AccessMonster.com

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
 
L

LarryP

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.
 
Top