UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Exporting to .txt    
 
   
donpayseur
post Dec 20 2004, 12:55 PM
Post #1

UtterAccess Addict
Posts: 235
From: Charlotte, NC
Hello all,
Well, I feel whipped on this one. First hanks to Crystal and Ricky for their fine assistance on this request over the weekend. I am reposting because the post is getting old. What I am trying to accomplish is this: I have a table and I need to export the table to a delimited file with header on the first row. Here is what I have that doesn't work... at first I was trying to output to an .xls and then saving as a .csv but that was incorrect...Thanks for the help...
Down and out Don

CODE
  

DoCmd.TransferText acImportDelim, , "truckstopOutput", "c:\truckposts\" & strDocName, -1, , ""
Go to the top of the page
 
+
strive4peace
post Dec 20 2004, 03:13 PM
Post #2

UtterAccess VIP
Posts: 20,209
From: Colorado
Hi Don,

acImportDelim???

also, I find it best to use a variable that is already calculated instead of concatenating on a command line

dim mOutputFile as string
mOutoutFile = "c:\truckposts\" & strDocName

DoCmd.TransferText acExportDelim , , "truckstopOutput", mOutputFile , -1
Go to the top of the page
 
+
donpayseur
post Dec 20 2004, 03:21 PM
Post #3

UtterAccess Addict
Posts: 235
From: Charlotte, NC
Ok let me try that too.
BRB

Also too Crystal, I appreciate your gracious amount of time. Would it be wise for me to zip up what I have codewise and let you see the big picture? I will be glad to do so.
Thanks
Don
Go to the top of the page
 
+
donpayseur
post Dec 20 2004, 03:26 PM
Post #4

UtterAccess Addict
Posts: 235
From: Charlotte, NC
I am trying this now...
Go to the top of the page
 
+
donpayseur
post Dec 20 2004, 03:31 PM
Post #5

UtterAccess Addict
Posts: 235
From: Charlotte, NC
Well, I will speak with a little caution, but it seems to be working.....I am now going into serious test mode with this and I will get back with you. It looks good.
Again, I just don't know how to say thanks. but THANKS!
Go to the top of the page
 
+
strive4peace
post Dec 20 2004, 03:34 PM
Post #6

UtterAccess VIP
Posts: 20,209
From: Colorado
you're welcome (IMG:http://www.utteraccess.com/forum/style_emoticons/default/wink.gif) happy for you
Go to the top of the page
 
+
« Next Oldest · Access Automation · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 23rd May 2013 - 05:30 PM