If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Import Specification
How do I setup a Import Specification in access?
-- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...arted/200909/1 |
#2
|
|||
|
|||
Import Specification
Assuming you want a specification for importing a text file:
You create an import specification by manually beginning the 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., "MyEImportSpec", for example). Click OK button to return to the main window of the wizard. Then click Cancel button to cancel the rest of the import. Now go to your TransferText code and add the name of the specification to the appopriate argument position. If you're using ACCESS 2007 and want to import an EXCEL file, then follow similiar instructions as above but for an EXCEL file. -- Ken Snell MS ACCESS MVP http://www.accessmvp.com/KDSnell/ "turks67 via AccessMonster.com" u48755@uwe wrote in message news:9ca72dc46b884@uwe... How do I setup a Import Specification in access? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...arted/200909/1 |
Thread Tools | |
Display Modes | |
|
|