Advertisement

06.19.2008 at 09:00AM PDT, ID: 23499418
[x]
Attachment Details

Access 2003: Append table data to a text file with code - VBA

Asked by JohnMac328 in Access Coding/Macros, Microsoft Access Database, Miscellaneous Programming

I need to append data from a table to a text file that has already been created with a DoCmd method.  Here is that
DoCmd.TransferText acExportFixed, "EXPORT_TABLE_Export_Specification", "EXPORT_TABLE", "C:IA_Subscriptions\Test.txt"

It works fine but now I want another line that appends data from another table to the text file.  Any help is greatly appreciated.

JohnStart Free Trial
 
Keywords: Access 2003: Append table data t…
Title
1 Cancelling a DoCmd
2 docmd
3 Appending a table from a form
4 Subscript out of Range Error on Acces…
5 DoCmd Question.....
6 Append record to table from VBA even…
 
Loading Advertisement...
 
[+][-]06.19.2008 at 09:09AM PDT, ID: 21823644

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.19.2008 at 09:12AM PDT, ID: 21823674

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.19.2008 at 09:18AM PDT, ID: 21823734

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Access Coding/Macros, Microsoft Access Database, Miscellaneous Programming
Sign Up Now!
Solution Provided By: rockiroads
Participating Experts: 2
Solution Grade: A
 
 
[+][-]06.19.2008 at 09:33AM PDT, ID: 21823879

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628