If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
end of line
I want to write importing CSV file into a access table. How can I deal with
the end of line? PLease advise. Thanks. |
#2
|
|||
|
|||
end of line
Eric, can you clarify your question? Are you just trying to import a CSV
file via code or a macro? Destin Richter "-00Eric Clapton" wrote: I want to write importing CSV file into a access table. How can I deal with the end of line? PLease advise. Thanks. |
#3
|
|||
|
|||
end of line
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). -- HTH Van T. Dinh MVP (Access) " -00Eric Clapton" wrote in message ... I want to write importing CSV file into a access table. How can I deal with the end of line? PLease advise. Thanks. |
#4
|
|||
|
|||
end of line
Using code.
"Destin Richter" wrote in message ... Eric, can you clarify your question? Are you just trying to import a CSV file via code or a macro? Destin Richter "-00Eric Clapton" wrote: I want to write importing CSV file into a access table. How can I deal with the end of line? PLease advise. Thanks. |
#5
|
|||
|
|||
end of line
Can anyone please help? Thanks.
" -00Eric Clapton" wrote in message ... Using code. "Destin Richter" wrote in message ... Eric, can you clarify your question? Are you just trying to import a CSV file via code or a macro? Destin Richter "-00Eric Clapton" wrote: I want to write importing CSV file into a access table. How can I deal with the end of line? PLease advise. Thanks. |
#6
|
|||
|
|||
end of line
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....b92a91836bcdd4 -- Brendan Reynolds " -00Eric Clapton" wrote in message ... Can anyone please help? Thanks. " -00Eric Clapton" wrote in message ... Using code. "Destin Richter" wrote in message ... Eric, can you clarify your question? Are you just trying to import a CSV file via code or a macro? Destin Richter "-00Eric Clapton" wrote: I want to write importing CSV file into a access table. How can I deal with the end of line? PLease advise. Thanks. |
#7
|
|||
|
|||
end of line
I am reading one line at a time. Can you please help? Thanks.
"Van T. Dinh" wrote in message ... 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). -- HTH Van T. Dinh MVP (Access) " -00Eric Clapton" wrote in message ... I want to write importing CSV file into a access table. How can I deal with the end of line? PLease advise. Thanks. |
#8
|
|||
|
|||
end of line
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) -- HTH Van T. Dinh MVP (Access) " -00Eric Clapton" wrote in message ... I am reading one line at a time. Can you please help? Thanks. |
#9
|
|||
|
|||
end of line
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? "Van T. Dinh" wrote in message ... 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) -- HTH Van T. Dinh MVP (Access) " -00Eric Clapton" wrote in message ... I am reading one line at a time. Can you please help? Thanks. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Line color and style | dbragg | Powerpoint | 2 | June 29th, 2005 09:21 PM |
Line chart - date line association gone mad! | Johannes Czernin | Charts and Charting | 5 | January 17th, 2005 08:48 PM |
Line Numbering... (Cannot GoTo)!? | Jeffrey A. Voigt | Page Layout | 0 | July 30th, 2004 07:24 PM |
Outlook 2003: annoying line wrap when quoting | Tony Gravagno | General Discussion | 10 | July 18th, 2004 12:17 AM |
Discontinue part of line in chart | Jon Peltier | Charts and Charting | 0 | April 1st, 2004 10:27 PM |