auto import table from old excel format?

[romanticode]

i have 1 table that link to excel file. the excel file is generate by other software and it's on excel 2.1 format. I've tried to directly link to the file but not working. so i manually open the file and save the file on excel 2002 format, then i use that file to be linked on my mdb. Unfortunately every time i replace the file with the newest data, my mdb not displaying the updated data.

- how can i link old version of excel on mdb?
- what should i do so my mdb will display the updated data after the excel file is replaced?

thanks

 

[KenHigg]

Maybe you can open excel in access, open the old spreadsheet and save it in the new format. Then your link should work - ?

 

[romanticode]

so i manually open the file and save the file on excel 2002 format, then i use that file to be linked on my mdb.

thats what i'm doing now.

is there any metode to auto convert the file?

 

[KenHigg]

a. I have no idea what metode is.. ?
b. You said you were doing it manually, my suggestion was to automate it in access.