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.
the end of line? PLease advise. Thanks.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
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)
file via code or a macro?
Destin Richter
(e-mail address removed)
V
Van T. Dinh
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).
Method?
TransferText would be much faster and handle EOL automatically (used as the
Record separator).
0
-00Eric Clapton
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)
0
-00Eric Clapton
B
Brendan Reynolds
What is the problem you are having with the end-of-line? Does this CSV file
perhaps originate from a non-Windows system, e.g. a UNIX system? If it does,
my "LF2CRLF" function might help ...
http://groups.google.com/group/comp.databases.ms-access/msg/05b92a91836bcdd4
perhaps originate from a non-Windows system, e.g. a UNIX system? If it does,
my "LF2CRLF" function might help ...
http://groups.google.com/group/comp.databases.ms-access/msg/05b92a91836bcdd4
0
-00Eric Clapton
I am reading one line at a time. Can you please help? Thanks.
V
Van T. Dinh
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)
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)
0
-00Eric Clapton
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?
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?