Mirrored: 6th of February 2012, 15:08 Original: answers.microsoft.com Views: 10 Settings: Loading the mirror...
English * Cestina * Dansk * Deutsch * Espanol * Franc,ais * Italiano * Magyar * Nederlands * Norsk, Bokmaal * Polski * Portugues Sign in * Suomi * Svenska * Tu:rkc,e * Ellynika% * Russkij * E+B+R+J+T+ * a+l+e+r+b+y+tm * ********* * ********* * ******(******) * ******(******) * ********* [IMG] * Home * Windows * Office * Internet Explorer * Windows Phone * Microsoft Security Essentials * Zune * Office for Mac * Help [ ] Find answers [ ] Ask a question _____________________ [ Search ] Office _____________________ [ Ask ] * Office 2007 * Office * All forums Subscribe to this thread Tweet this question Share to Facebook Question Access 2007 VBA for exporting a query or form to .csv file? Applies To: Office | Office 2007 | Microsoft Office Access I have Access 2007 and i want to create a VBA for exporting a query or form to .csv and there is nothing i can find useful online? apparently there is no macro either with this command, and just exporting to a txt document is no good for me. I have even tried some other proggys etc to convert the txt to csv format but they didnt even work right. what i am expecting as a result is given below as an example.. Manufacturer,Registration Plate,Engine Number,Vin Number,Engine Size CC,Model Mitsubishi,HJT 345,685855jgjgjgjg,55588hhjjj,3.5L V6,Magna Peugeot,DFE 998,67755hghghg,fhjtr4t5g,2.0L,405 I have a query called "upload" and could do with vba that will work with access 2007. so anyone who can help because i don't know what to do now, please reply... * April 5, 2011 * Reply with quote * Report abuse * Child exploitation or abuse * Harassment or threats * Inappropriate/Adult content * Nudity * Profanity * Software piracy * SPAM/Advertising * Virus/Spyware/Malware danger * Other Term of Use or Code of Conduct violation [ Reply ] 1 Person had this question [ Me Too ] Email me random2008 random2008 * All Replies (7) * More Help Was this helpful? [ Yes ] 0 Look at the TransferText action (for macros), or DoCmd.TransferText method (for VBA) You might find http://www.databasejournal.com/features/msaccess/article.php/3853531/Working-with-external-text-files-in-MS-Access.htm useful as well. * April 5, 2011 * Reply with quote * Report abuse * Child exploitation or abuse * Harassment or threats * Inappropriate/Adult content * Nudity * Profanity * Software piracy * SPAM/Advertising * Virus/Spyware/Malware danger * Other Term of Use or Code of Conduct violation [ Reply ] DJSteele, MVP DJSteele, MVP MVP Community Star Doug Steele, Microsoft Access MVP <a href='http://www.AccessMVP.com/djsteele'>My Website</a> Was this helpful? [ Yes ] 0 In reply to DJSteele, MVP post on April 5, 2011 thank you for the info, but its not resolved my issue. * April 5, 2011 * Reply with quote * Report abuse * Child exploitation or abuse * Harassment or threats * Inappropriate/Adult content * Nudity * Profanity * Software piracy * SPAM/Advertising * Virus/Spyware/Malware danger * Other Term of Use or Code of Conduct violation [ Reply ] random2008 random2008 Was this helpful? [ Yes ] 0 In reply to random2008 post on April 5, 2011 What about it is not resolved? TransferText is THE way to export to CSV. Please help us understand why it did not work for you. Maybe you can include a code snippet. * April 5, 2011 * Reply with quote * Report abuse * Child exploitation or abuse * Harassment or threats * Inappropriate/Adult content * Nudity * Profanity * Software piracy * SPAM/Advertising * Virus/Spyware/Malware danger * Other Term of Use or Code of Conduct violation [ Reply ] Tom van Stiphout Community Moderator Tom van Stiphout MVP Community Star -Tom. Microsoft Access MVP Was this helpful? [ Yes ] 0 In reply to Tom van Stiphout post on April 5, 2011 hi Tom, thank you for your message. sorry mate, i had a look at the link http://www.databasejournal.com/features/msaccess/article.php/3853531/Working-with-external-text-files-in-MS-Access.htm and read the part about that. DoCmd.TransferText acExportDelim, _ "Standard Output", _ "qryAprilDetails", "C:\Txtfiles\April.txt however i am sorry that i am dumb when it comes to VBA stuff, sorry. So i anticipated this code didnt work with 2007 access and I will give it a try. Thankx guys... i will report back here shortly ;-) * April 5, 2011 * Reply with quote * Report abuse * Child exploitation or abuse * Harassment or threats * Inappropriate/Adult content * Nudity * Profanity * Software piracy * SPAM/Advertising * Virus/Spyware/Malware danger * Other Term of Use or Code of Conduct violation [ Reply ] random2008 random2008 Was this helpful? [ Yes ] 0 In reply to random2008 post on April 5, 2011 hi guys. back again.. the Simplistic Approach goes on about "importing" and like i have mentioned i am wanting to export. the importing also guides thru creating / saving specification, etc. what will the vba be for exporting to csv. I imagine it will be the TransferText ? now that i know the transfertext command is what i need to be looking for, i just need to sort the vba script for it. * April 5, 2011 * Reply with quote * Report abuse * Child exploitation or abuse * Harassment or threats * Inappropriate/Adult content * Nudity * Profanity * Software piracy * SPAM/Advertising * Virus/Spyware/Malware danger * Other Term of Use or Code of Conduct violation [ Reply ] random2008 random2008 Was this helpful? [ Yes ] 0 In reply to random2008 post on April 5, 2011 While I admit I talk about importing, after the sample code you posted DoCmd.TransferText acExportDelim, _ "Standard Output", _ "qryAprilDetails", "C:\Txtfiles\April.txt" I explicit state that "In that example, the details stored as specification "Standard Output" would be used when exporting the data produced by qryAprilDetails to table C:\Txtfiles\April.txt" (emphasis added) * April 5, 2011 * Reply with quote * Report abuse * Child exploitation or abuse * Harassment or threats * Inappropriate/Adult content * Nudity * Profanity * Software piracy * SPAM/Advertising * Virus/Spyware/Malware danger * Other Term of Use or Code of Conduct violation [ Reply ] DJSteele, MVP DJSteele, MVP MVP Community Star Doug Steele, Microsoft Access MVP <a href='http://www.AccessMVP.com/djsteele'>My Website</a> Was this helpful? [ Yes ] 0 In reply to DJSteele, MVP post on April 5, 2011 Hi Doug & Tom... sorry for not been uptodate with this kind of stuff, but the information you both have given me has been enough to fix the problem i had. So a big thank you and thank you for not calling me stupid, lol... I chased up the info and I have managed to sort out the "specified field" and i didnt realise that even though i wanted to export the csv info, i first had to create a text file import, then thru advanced and making a specified field" etc and then going in to creating a new macro and "show all" for the actions, to then choose the transfertext, to choose all the necessary outputs. so im almost there, and if it wasnt for you two guys i think i would have been stuck for a while longer , because i was stuck on this for a few days. grrr. Field1,Field2,Field3,Field4,Field5,Field6,Field7 Manufacturer,Registration Plate,Engine Number,Vin Number,Engine Size CC,Model Mitsubishi,HJT 345,685855jgjgjgjg,55588hhjjj,3.5L V6,Magna Peugeot,DFE 998,67755hghghg,fhjtr4t5g,2.0L,405 so i just got to get rid of this field stuff at the top which sohuld be done tomorrow, because its 0126am in australia and i need to sleep. Thankx guys !!! * April 5, 2011 * Reply with quote * Report abuse * Child exploitation or abuse * Harassment or threats * Inappropriate/Adult content * Nudity * Profanity * Software piracy * SPAM/Advertising * Virus/Spyware/Malware danger * Other Term of Use or Code of Conduct violation [ Reply ] random2008 random2008 * Please try a lower page number. * Please enter only numbers. _________________________________________ _________________________________________ _________________________________________ _________________________________________ _________________________________________ _________________________________________ _________________________________________ [ ] Notify me when someone responds to this question [ ] Abuse removed [ Submit ] [ Cancel ] [ Delete Post ] * Contains adult content * Mark as spam [ ] Message marked as answers cannot be deleted To delete this message, first unmark this message as an answer, then delete it. [ OK ] [ ] Reason to remove escalation _________________________________________ _________________________________________ _________________________________________ _________________________________________ _________________________________________ [ Submit ] [ Cancel ] [ ] Merge Enter the thread ID of the thread you are merging into _____________________________________________________________ Invalid Thread Id [ Submit ] [ Cancel ] [ ] Reply will be posted to a public thread You are replying to a public portion of this thread. To reply privately, click Cancel, click the Private Messages tab, and Reply on that private message. [ ] Don't show this message again [ OK ] [ Cancel ] [ ] To report abuse, sign in or continue without signing in [ ] Thank you. [ OK ] [ ] Report abuse Abuse type: Details (optional): _____________________ _____________________ _____________________ _____________________ _____________________ [ Submit ] [ Cancel ] [ ] Report abuse Abuse type: Details (required): _____________________ _____________________ _____________________ _____________________ _____________________ Enter the characters you see (required): Type the numbers that you see in the picture. Play audio and Play audio and type the numbers that you hear. type the numbers that you hear. Use picture mode. Show a different picture. Type the numbers that you hear. If you cannot understand the audio, you can replay it, or click the refresh button to hear a different set of numbers. [ Play audio ] _____________________ [ Submit ] [ Cancel ] [ ] [ OK ] (c) 2012 Microsoft * Answers Code of Conduct * Answers Feedback * Trademarks * Privacy Statement * Terms of Use [ ] Sign in liveIDicon Sign in using Windows Live ID Hotmail, Xbox Live, Messenger, or msn accounts will also work. -------------------------------------------------------------------------------------------------------- Don't have one of the above accounts? Sign up now for a Windows Live ID account. Signing in... This page will automatically update after you are signed in. If you are having problems, you can close this message and try to connect again. [ Cancel ]
Related mirrors
insight bowl russell brand files for divorce bowl game schedule julia child clippers katy perry and russell brand katy perry divorce
No comments:
Post a Comment