end of line

  • Thread starter Thread starter -00Eric Clapton
  • Start date Start date
0

-00Eric Clapton

I want to write importing CSV file into a access table. How can I deal with
the end of line? PLease advise. Thanks.
 
Eric, can you clarify your question? Are you just trying to import a CSV
file via code or a macro?

Destin Richter
(e-mail address removed)
 
Are you reading one line of the CSV file at a time or using TransferText
Method?

TransferText would be much faster and handle EOL automatically (used as the
Record separator).
 
Using code.

Destin Richter said:
Eric, can you clarify your question? Are you just trying to import a CSV
file via code or a macro?

Destin Richter
(e-mail address removed)
Click to expand...
 
I am reading one line at a time. Can you please help? Thanks.
 
Is the EOF signifies the end of the Record?

Is there any reason you are not using TransferText? (which is a lot easier
and much more efficient than reading and processing one line at a time)
 
Yes, EOF signifies the end of record. The reason I am using coding instead
of transfer text because my importing process is complicated. It's not just
a simple field to field import. Is there a way to detect the end of line in
CSV, if I do it this way?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Which is the best MBOX Converter Tool different formats conversion? 4
Access Importing csv daily files into access 2007 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Problem with access acImportDelim importing csv with headers 1
How to export table from outlook into ms access table? 0
How can I import to Access 2003 from csv-file via VBA? 4
display just the first element in a field on a form 2
How to export Access data to Quickbook? 4

Back
Top