Transferspreadsheet

[Davecg2]

Im trying to use the transferspreadsheet method to export a table, the code works fine if i have the table in the local database, but i seperate the code and data into seperate files, is there a way to specify the database and tablename when using the transferspreadsheet method?

 

[Davecg2]

ok not trying to bump new to this forum and dont see an edit button so.... i am used to using this method when the table is in the same db as the code, i only need help with making it work when the table is in another database and would prefer not to just do a generic fix and link the table.