MS Access = Importing data w/ column titles in row N=

[WalterContrata]

Please help out an Access newbie.

I'm importing data from a csv file to Access. The csv file has column titles, but they are not in the first row, which I use for a header. The header contains data about how the data were taken, (e.g. by who, with what equipment).

An example csv file is at

http://www.geocities.com/straight_manus/WIP/TextFileForImportToAccess.zip

When I import these data into an Access table, is there any way to get Access to recognize the column titles, even though they are not in Row 1? Can I get Access to store the header information along with the table, say, as a comment?

 

[SkipVought]

Hi,

Looks like it's either the first row headings or NOT.

Very Standard!

Other than that, you'd need a VB program to do it.

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}

 

[WalterContrata]

Skip,

Thanks.

I'm considering doing it in VB, but most of our users probably would prefer to do the import manually.

Walter