bill201
asked on
how to export from microsoft access 2010 to txt (tab delimited)
hi
i asked this question yesterday, and i get an answer, and i accepted, and i closed the question; but i have still difficult so i will ask the question again;
i will show you exact what i need, and i hope that someone will be able help with this.
i attached a file called finance.txt, and this file contained data that i make manually, and i need to can make file exact like with vba.
so i attached an access database with a table that called table1 and in this table has the same data like in the finance.txt file and the database have a form with a command button "export" but it's not have any code behind that.
so i need a vba code (to the export button) to make that it's will export the data on the table "table1" to a file that will seems exact like the finance.txt file
thanks a lot
finance.txt
sample.mdb
i asked this question yesterday, and i get an answer, and i accepted, and i closed the question; but i have still difficult so i will ask the question again;
i will show you exact what i need, and i hope that someone will be able help with this.
i attached a file called finance.txt, and this file contained data that i make manually, and i need to can make file exact like with vba.
so i attached an access database with a table that called table1 and in this table has the same data like in the finance.txt file and the database have a form with a command button "export" but it's not have any code behind that.
so i need a vba code (to the export button) to make that it's will export the data on the table "table1" to a file that will seems exact like the finance.txt file
thanks a lot
finance.txt
sample.mdb
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
did you use an export specification to create the text file?
if you did, upload a copy of the db with the export specification..
if you did, upload a copy of the db with the export specification..
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks a lot for you both
sorry that i don't response Up to now, i don't was in town and i was not able to test this code. now the two codes are working perfect
sorry that i don't response Up to now, i don't was in town and i was not able to test this code. now the two codes are working perfect
ASKER
honestly i don't know. i think that its not fixed width. i will try to import (in my other software that called finanda) from this file like is it and i hope that is will be a successful....