|
| 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
October 31st, 2005, 03:14 AM
|
|||
|
|||
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
October 31st, 2005, 07:07 AM
|
|||
|
|||
|
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
October 31st, 2005, 02:36 PM
|
|||
|
|||
|
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
November 1st, 2005, 01:35 AM
|
|||
|
|||
|
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
November 1st, 2005, 05:21 AM
|
|||
|
|||
|
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
November 1st, 2005, 10:59 AM
|
|||
|
|||
|
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
November 3rd, 2005, 04:59 AM
|
|||
|
|||
|
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
November 3rd, 2005, 01:54 PM
|
|||
|
|||
|
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
November 4th, 2005, 12:16 AM
|
|||
|
|||
|
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 |
Linear Mode
