i got excel 2002 (office XP): how can i save a spreadsheet so...

[yaz]

access 97 can open it ?

with access i reference DAO 2.5/3.51
instead 3.6 and when opening with 2000 or xp, it asks
me if i want to convert.

but for excel, i have only one choice: Excel 10 library.

any ideas ?


thank you

[jim mcnamara]

Go into Excel, start recording a macro - then do a Save as CSV file. Stop recording. Now you have the VB script to make a csv file.

Access can import csv files directly. IF you don't know the code, resort to the macro approach. Except that, in Access 97, you have to explicity convert the Access macro to VBA - it's a menu option on the macro menu.

[yaz]

so:

1234
qwer
asdf
0987

i've got these 4 entries in a string array

i want to save them as excel 97 or access 97
i can easily do it as Access/Excel/2002 but it took me a while to do it for Access/Excel 97. it's done now

whaen i open a db saved that way, i got the message ....do you want to convert that ol' junk...


tx