importing csv chops first line

  • Thread starter Thread starter Brian Lorraine
  • Start date Start date
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.
 
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?
 
Back
Top