URGENT! Linking Tables

[vanillapod]

Hi I have a large database that exports data as an excel file. This file can then be emailed by a user to a remote user who can use a smaller database to edit the data in the excel file b4 sending it back to be re-imported into the main database.

Anyway I'm using the following to link to the xls file:

DoCmd.TransferSpreadsheet acLink, 8 etc etc...

Some of the fields are being linked as text fields when they have to be numeric fields.... is there a way I can force the field types on the linked xls file? Maybe I could set the field types when the xls is created by the first main database???/

Please help!

 

[vanillapod]

My xls has field names that are all text would this be influencing the field type when they are linked to my smaller db?