Import/Export Specification 2002

O

octet

I am using access 2002 can I create a Import/Export Specification?
I have a book called Access Data Analysis Cook Book that say I can but I
have not been unable to find it.
the book says to Choose the External Data command tab I cant find it.
Can this be done with 2002?
thanks
 
K

Ken Snell MVP

You create an Export (or Import) Specification by manually beginning the
export (or import) process (via File | Export). When you're in the wizard
window, click the Advanced button at bottom left. In the new window, you'll
see all the settings you' can specify. Enter all the information. Click Save
As button and save them as a specification (name it whatever you want, e.g.,
"MyExportSpec", for example). Click OK button to return to the main window
of the wizard. Then click Cancel button to cancel the rest of the export.

Now go to your TransferText code and add the name of the specification to
the appopriate argument position.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error Saving Import/Export Spec 1
Import/Export Specification Error 1
Import/Export specification 8
Maintaining Field (Column) Order on Import and Export in Access 20 0
Import error "The specification XML failed to validate " 4
Export Specification Question 3
'Advanced' option with export wizard 1
Delimited Export Specification - independent of table 3

Top