importing csv chops first line

B

Brian Lorraine

I have a program written in access 2002/vba which takes a
delimited file (the delimiting character is "|" if it
matters) and imports it into a table. If I go to TABLES-
new->import table, select the file and all import wizard
Click to expand...
menus, it imports just fine.

However, when I use the TransferText/Import Delimted
method (either via code or macro) to import using the same
file and schema that I saved before, the very first
line/record of the file does not get imported. There is no
header line in the file. The schema does not have the
first line set as header either.
 
J

Joe Fallon

Are you setting the "hasfieldnames" parameter to False in your TrasferText
command?


I always use column headers in the first line of the file.
Try adding them and see if it works.

If it does, can you use them in future versions of the file?
 
Top