Trying To Get a CSV File To Import into a Table by Code

[Guest]

I am using Syware's Visual CE to "Export" ASCII files.

I have VBA code (courtesy of "smartin" in this Newsgroup) that strips
the First Row of "Column (Table) Names" in the ASCII file.

I am having trouble using an Access 2003 Import Specification getting
the data into a predefined Table.

Is there anyone willing to look at the simple CSV file of 2 Records???
If you, please reply here, or best, send an email to (e-mail address removed)
and (e-mail address removed)....so I can send the file to you.

TIA - Bob

 

[John Vinson]

I am using Syware's Visual CE to "Export" ASCII files.

I have VBA code (courtesy of "smartin" in this Newsgroup) that strips
the First Row of "Column (Table) Names" in the ASCII file.

I am having trouble using an Access 2003 Import Specification getting
the data into a predefined Table.

Is there anyone willing to look at the simple CSV file of 2 Records???
If you, please reply here, or best, send an email to (e-mail address removed)
and (e-mail address removed)....so I can send the file to you.

TIA - Bob

Did you get anywhere with this import problem, Bob? I'd be willing to
take a look at it - send to jvinson <at> wysard of info <dot> com
(remove the blanks and make the obvious edits).

John W. Vinson[MVP]