column Name

  • Thread starter Thread starter Mark Lewis
  • Start date Start date
M

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
 
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
 
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
Click to expand...

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