Importing text files to another database

  • Thread starter Thread starter BD
  • Start date Start date
B

BD

It's possible do Import text files to another database directly?
I'm working with front end and I want to call the TransferText to
import the file to the back end database. Or I must to import to the
front end and then transfer the table to the back end and after that
delete the table in the front end?

[]'s
BD
[]'s
BD
 
Create a new table in your back end, then import the text file by File | Get
External Data | Import.

After the data has been imported, go to your front end and link tables by
File | Get External Data | Link Tables. Find your backend and new table with
imported data.

Hope this helps

Martin
 
Thanks Martin I really didn't expose my question correctly, sorry.
I know do that like you mentioned. I mean how can I do the import into
another database through code (VBA) from the front end? After that I
know how to link the table from the back end to front end.

[]'s
BD
 
Back
Top