column Name

[Mark Lewis]

Hi All,

Is there a way I can imports a csv file to automatically name my columns,
the data will the added after and is going to all be text?

Regards

Mark

 

[Jeff Boyce]

Mark

Instead of importing, consider linking to the csv file, and using an append
query to take (appropriate) data from the (linked) csv file and place it
into (well-normalized) Access table(s).

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John W. Vinson]

Hi All,

Is there a way I can imports a csv file to automatically name my columns,
the data will the added after and is going to all be text?

Regards

Mark

I'd agree with Jeff about the best way to do it; another way is to use a text
editor to insert a first row in the file with the fieldnames, and specify that
you have done so to the import wizard.