Exporting a linked table

[louiserome]

I currently have a multi user database that I have recently split. With the front end on the local drive and the back end on the network. For a particular process I need to export a table to another external database. My problem is that since I've split it it keeps exporting the table but it sits in the external database as a linked table. How do I get it to export the original table??
Many Thanks in advance

 

[doss]

Can you open up the External Database instead, right click in the table window and just import the table from the split database???

 

[louiserome]

Yes I can do it manually, but it's something that is done on a regular basis and is done automatically by queries and VB code. Is there someway that from the split database I can write some code that will export the table from the back end database (the original table) as opposed to the front end??