Transferspeadsheet Question

[durdle]

Hey,

I have the transferspreadsheet macro setup to import an excel file but if the file is not open I get the following error
"External Table isn't in the expected format"
but if I open the file and run the macro I receive no error and the data imports correctly.

Any Ideas?

Thanks
________
honda activa specifications

 

[IMO]

Try this on the click event of a button

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel97, "YourTableName", "c:\YourExcelFile.xls", True

Or have a look here

http://www.access-programmers.co.uk/forums/showthread.php?s=&postid=185557#post185557

IMO

 

[durdle]

Hi IMO,

Thanks for the reply but I still get the following error.
"External Table isn't in the expected format"

durdle
________
toyota rz engine specifications

 

[IMO]

Are all the columns named the same in the spreadsheet?

IMO

 

[durdle]

Hi IMO,

Yes. All the column names never change.
This seems pretty simply or am I that dump.

durdle
________
w107 350sl

 

[IMO]

Hi durdle,

Sorry I didn't get back to you yesterday, had a meeting. I've created you an example that searches for .xls files and then imports them. It's in A2k, let me know if you need 97 version. Hope this works for you, let me know

IMO

 

[durdle]

Hi IMO,

If you could put them in 97 it would be great.

durdle
________
herbal vaporizers

 

[IMO]

Here you are, hope it works for you

IMO

 

[durdle]

Thanks again IMO,

Just one wondering why is there code in the Form_Timer() and Form_Open. I can understand the reason in Form_Open, because it checks the C:\ for new files but I don't understand the Form_Timer()?
Any help would be great.

durdle
________
ford 300 (1963)

 

[IMO]

I set it in the form timer so, if you open the form and there is no data to import, you can leave it open and when files are placed in the Import folder they are shown in the listbox and the import button becomes active. I did this originally because I had Access talking to a weigh machine that exported .csv files to a certain folder every 5 minutes and the user wanted to see how many files were ready for import without having to close and open the form.

Hope this helps

IMO

 

[bionicman]

I got a question about the above example. I hope you still post here (or someone else that might know). Is there anyway to have each excel file listed on a new line in the list box so they do not all run together?

 

[Late4Supper]

Check out the work by Cosmos75 and Oldsoftboss in the Sample Data base section of this forum (search on common)

 

[bionicman]

thanks for the reply, but i already had it figured out... all i had to do was add a comma

 

[Late4Supper]

Okey Dokey