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
|
|||
|
|||
TransferText Method
Hello All,
I want to import a text file using the bar | as a delimiter to separate the fields, and all the fields should come in to the table as text data type. I cant get it to work. Can you please give me an example how to use the Docmd.TransferText command with all the arguments. Thanks in advance. Abe |
#2
|
|||
|
|||
TransferText Method
Abe,
This would need to be set up in your Import Specification. To get a more detailed description of how to go about that you need to tell us what version of Access as instructions vary based on version. -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Abe Katz" wrote in message ... Hello All, I want to import a text file using the bar | as a delimiter to separate the fields, and all the fields should come in to the table as text data type. I cant get it to work. Can you please give me an example how to use the Docmd.TransferText command with all the arguments. Thanks in advance. Abe |
#3
|
|||
|
|||
TransferText Method
Hi Gina,
Thanks for getting back, I'm using Acc2003. Abe "Gina Whipp" wrote in message ... Abe, This would need to be set up in your Import Specification. To get a more detailed description of how to go about that you need to tell us what version of Access as instructions vary based on version. -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Abe Katz" wrote in message ... Hello All, I want to import a text file using the bar | as a delimiter to separate the fields, and all the fields should come in to the table as text data type. I cant get it to work. Can you please give me an example how to use the Docmd.TransferText command with all the arguments. Thanks in advance. Abe |
#4
|
|||
|
|||
TransferText Method
Abe,
Open Access... 1. Go to File - Get External Data - Import 2. Select you file on in the window that opens - Import Text Wizard click the Advanced button... 3. Set up your specifications and don't forget to save... 4. Then use your saved Import Specification with a TransferText statement... -From the help file... DoCmd.TransferText acExportDelim, "Standard Output", "External Report", "C:\Txtfiles\April.doc" -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm.. "Abe Katz" wrote in message ... Hi Gina, Thanks for getting back, I'm using Acc2003. Abe "Gina Whipp" wrote in message ... Abe, This would need to be set up in your Import Specification. To get a more detailed description of how to go about that you need to tell us what version of Access as instructions vary based on version. -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Abe Katz" wrote in message ... Hello All, I want to import a text file using the bar | as a delimiter to separate the fields, and all the fields should come in to the table as text data type. I cant get it to work. Can you please give me an example how to use the Docmd.TransferText command with all the arguments. Thanks in advance. Abe |
Thread Tools | |
Display Modes | |
|
|