TransferText Method
in [Form]
|
From: Abe Katz on 12 Mar 2010 16:10 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
From: Gina Whipp on 12 Mar 2010 21:17 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" <abekatz(a)mindspring.com> wrote in message news:OEMwZiiwKHA.5936(a)TK2MSFTNGP04.phx.gbl... 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
From: Abe Katz on 14 Mar 2010 18:38 Hi Gina, Thanks for getting back, I'm using Acc2003. Abe "Gina Whipp" <NotInterested(a)InViruses.com> wrote in message news:F85FA58C-9C72-46F0-A492-19D1D370F0C0(a)microsoft.com... > 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" <abekatz(a)mindspring.com> wrote in message > news:OEMwZiiwKHA.5936(a)TK2MSFTNGP04.phx.gbl... > 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 >
From: Gina Whipp on 14 Mar 2010 20:28 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" <abekatz(a)mindspring.com> wrote in message news:#Z#Rec8wKHA.3304(a)TK2MSFTNGP06.phx.gbl... Hi Gina, Thanks for getting back, I'm using Acc2003. Abe "Gina Whipp" <NotInterested(a)InViruses.com> wrote in message news:F85FA58C-9C72-46F0-A492-19D1D370F0C0(a)microsoft.com... > 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" <abekatz(a)mindspring.com> wrote in message > news:OEMwZiiwKHA.5936(a)TK2MSFTNGP04.phx.gbl... > 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 >
|
Pages: 1 Prev: Text Box in Forms Next: Can a form linked to an autoLookup query update another table |