Saving Excel format from web based application

  • Thread starter Thread starter ccfatzin
  • Start date Start date
C

ccfatzin

Hi all....my question involves exporting excel spreadsheets from a Web
application and having them saving in Excel 97-2002 format. Currently
the spreadsheets save as "Microsoft Excel Spreadsheet" and are not
compatible with Access 2002. I have to open the spreadsheets and then
save them in the correct format in order for my Access macro to import
the data. Is there anyway to tell Excel that anytime this specific
file is saved to save it in Excel 97-2002 format? If not.....is there
a way to adjust my Access import to update the Excel format before
importing the file? What I am trying to do is not have the users of
this database have to seek out the Excel file....open it.....re-save it
in the new format.....and then commence with the Macro in Access.

Any help is MUCH appreciated. Thanks....

-Chris
 
the problem is that Microsoft is run by a bunch of Excel dorks and they
refuse to take Access seriously.

THIS DOESNT WORK RELIABLY and Microsoft needs to fix it

I am working on a commercial spreadsheet-importing / auditing tool

I just basically reccomend importing the whole XLS usign 'sheet1,
sheet2, sheet3'-

if you use ADOX to get these; it handles a lot more reliably than using
Excel automation

HTH i would love to help you more but u need to give me more info
 
Back
Top