Question about Docmd??

[Karen C]

Can someone please explain how this works.

DoCmd.TransferText
acImportFixed, "ScannerInputData", "ScannerInputData",
MyName, False

I know the parameters are transfertype, specificationname
(which is suppose to be an .ini file, which I can't find
but in the code above it is the same name as my table
ScannerInputData), tablename, filename, and hasfieldnames.

I would appreciate any help

Karen

 

[gandalf]

Never done it via an ini file.

I found it easier to import it once via the import wizard.
file->external data->import
chose your textfile
chose advanced on the first(?) screen where you see the
rude layout

After you have filled in the fieldnames, save it as an
import-specification. (save as)

Then it is saved in MSysIMEXSpecs & MSysIMEXColumns
(system tables) in case you need to copy it to other
databases.


DoCmd.TransferText
acImportFixed,nameofimportspecification,nameofAccessTable,
locationofsourcetextfile, hasfieldnamesYN

Any further questions?

 

[JohnFol]

Basically it fires off an import from a text file

 

[Guest]

Thank you. I inherited this database and I was trying to
figure out where to find the specifications for the
Transfer. Thanks a million.

Karen