Importing an Excel file

[lars7]

Hi,
I'm trying to import an excel file straight into the back end of my database as I'm getting a numeric field overflow going through my front end. I've tried everything to fix this and this is my latest Idea but if anyone knows a better on one please let me know. Here is the code I'm trying but i get a meassage box saying that it doesn't follow the naming rules.

DoCmd.TransferSpreadsheet acImport, 8, "I:\DATACOLL\J.E.D._be.mdb\tblassimilation", "C:\Documents and Settings\tom\My Documents\assimilationupdate.xls", True,

 

[JerryKlmns]

DoCmd.TransferSpreadsheet acImport, 8, "tblassimilation", "C:\Documents and Settings\tom\My Documents\assimilationupdate.xls", True, ""

 

[lars7]

Hi Jerry,
Thats the code i was using that producess the numeric field overflow, I thought I would try to send it straight to the backend table, is this possible.

 

[lars7]

Hi,
I have got around the problem by Importing the file into my frontend and then running an append query to the table in the backend. I'm sure there was an easier way to do this but I have discoverd now that you can append to a table in another database so "every cloud has a silver linning