Question about Docmd??

  • Thread starter Thread starter Karen C
  • Start date Start date
K

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
 
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?
 
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
 
Back
Top