Import File

[Guest]

Hi,

I am importing a text file using the "TransferText" in the Macro's part of
Access.

The problem I am having is that the file is deliminated by ";" but I think
access is anticipating "," instead.

Is there a way to tell acess to deliminate by ";"
Office 2003

Thanks for your help.

 

[Ken Snell \(MVP\)]

You'll need to create an Import Specification in which you specify the
delimiter, and then use the name of that Import Specification as the second
argument of the TransferText method.

You create an Import Specification by manually beginning the import process.
When you're in the wizard window, select the ; character as the delimiter,
and set any other settings you want (field names, data types, etc.). Then,
before you click the Finish button, click the Advanced button at bottom
left. In the new window, you'll see all the settings you've specified. Click
Save As button and save them as an import specification (name it whatever
you want, e.g., "MyImportSpec"). 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 macro/code and add the name of the import
specification to the appopriate argument position.