Import using TransferText (Access97/2k)

Topic

New Reply

I decided to split a new db I’m working on.
I use a routine to link tables when opening and un link when closing. This saves from using the linked table manager if they move the db to another folder….Anyway
I import a monthly text file into the db using TransferText method and an import specification.
Now that it will be split, I want to import the file to the backend. I didn’t see anything in the syntax of the TransferText method to specify the path for the database. Is this possible or do I have to import the file, copy the table to the back end and then delete the table in the front end?
Scott

Reply | Quote

Replies

Will importing into a linked table work for you?

Reply | Quote

Paul,
As long as it gets put into the back end.
Scott

Reply | Quote

If the table is linked to the backend then the data will be in the backend.

Reply | Quote

How do you import to a linked table?
Scott

Reply | Quote

The same way you import to a table in the current db. I just tried it before my first post and it worked fine.

Reply | Quote

Paul,
I’m working from the front end of the database using:
DoCmd.TransferText acImportDelim, “RMAP_IMPORT”, Format(strDATE, “MM/YYYY”) & “_” & “RMAP30”, “C:” & Format(strDATE, “MM”) & “_” & “RMAP30.TXT”
to import. It imports into the front end not the back end like I need it to.
Scott

Reply | Quote

Right, you have to first create a table in the backend, link to it in the frontend then run your import into the linked table. i wasn’t sure if this scenario would work for you which is what I was really asking in an earlier post. Does the table change each time you import or are you overwriting data?

Reply | Quote

Paul,
A new table is added each month with a new table name using the mm/yyyy_RMAP30 format.
I guess I’ll stick to the original idea of importing, copying to the back end and then deleting the original.
Thanks,
Scott

Reply | Quote