Link a table from VB

[gr8whitewaldron]

Hello, I am attempting to utilize the TransferSpreadsheet function in VB to link a table to my current database. However, there is no SpreadSheetType reference for other access databases. Is this the wrong command to use or is there a reference for an access table?

 

[cghoga]

Have you tried or thought about creating an ODBC connection to the table?

Right click in Table Design View, Choose Link Tables..., etc.

You can maintain a continuous connection to the table this way without having to run a VB proc.

Hope this helps you.

 

[gr8whitewaldron]

The thing is, the table will be filled with information and then sent back to the home computer. So it doesn't quite exist yet to make a connection to it. ODBC is a little beyond me at the moment. DoCmd.TransferDatabase I believe is what I am looking for.

Thanks anyway!