hi,
i am trying to find out if it is possible to pass the current recordset of a form to DoCmd.TransferT ext so i can export it as a .csv
I know I can use querydefs etc, but it would be a much nicer solution if i could just loop through my subform1 and get the nested subform2 recordsets and pass them to the routine.
has anyone had experience with this ?
any ideas would be overwhelmingly appreciated!!
3 results in 0.0038 seconds.
-
sakurako97 started a topic Is it possible to pass the current form's Recordset to DoCmd.TransferTextin AccessIs it possible to pass the current form's Recordset to DoCmd.TransferText
-
DoCmd.Transfer Text: export to .csv
I’m trying to use DoCmd.TransferT ext, (I use it successfully with a .txt export every day) to export a table into a CSV file.
Right now every time I try – it says:
I just put a simple button on a form, and linked it to the onClick action...Code:Run-time error 3011 The MS Access db engine could not find the object ‘Inventory#scv’. Make sure the object exists and that you spell its name and the path name correctly.
-
DoCmd.TransferText acImportDelim
I'm trying to import a tab delimited text file.
The text file does not have column heading. I can give it column
heading if needed. How do I change the defult comma delimited to tab?
If I need a specification file, what does one look like or how can I
create a specification file.
I have over 400 tables I need to import into the corresponding table in
access. The tables in access all ready...
