what am i doing wrong ?

[technician]

i am trying to import an .xls file into a table and i am useing the command

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "TEST", "C:\AREA-DATA\11.XLS"

as i run the command it reports back

runtime error 3011

the microsoft jet engine could not find the object. make sure the object exists and that you spell its name and the path name correctly

if i change the acimport to aclink, the file links on

paul

 

[Oldsoftboss]

I came across this error and the only way I could fix it was to declare a few variables.

At work we connect to air conditioning controllers and have the ability to download log history. The program to download and display as graphs (a bit fancier than this) is over $1000

So I made this example to import a particular range of cells and display them as a graph as the free version of their software will allow you to save data in .csv format. I found that the heading was always in the same cell and the no of records was also there.

Hope it helps.

Dave