Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

importing and exporting

Status
Not open for further replies.

breilly192

Technical User
Nov 19, 2002
16
US
I created an import macro utilizing the TransferText action, however, it requires the specific file name to be typed into the Action Arguments. Can an InPut Box be used to prompt the user to select the file they want and then incorporate that into the macro or would it be better to just run a DoCmd in VB?

On the other end, exporting a file with a macro that uses the OutputTo action the file format is limited to .xls if I want to use the exported data as a load file for another system. When I tried .txt format the exported file included field borders and other report-type features that make it unusable as a data file. I'd prefer to have a tab-delimited output file but it isn't an option in the format selections within Access action arguments for the macro. I can export to .xls and then save it as tab delimited, but that is a step I'd like to eliminate in order to automate this as much as possible for the user.

Any help here would be appreciated. If it can be done within Access macros would be ideal, however, if it can be done through VB modules that would be good, as long as it's not too complex for my non-programmer mind to grasp.
 
Use VBA Code to do the TransferText

look at this thread I had a whole discusssion how to create a spec and call the file throgh code.

thread705-598060
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top