Microsoft has done it again. I been working on importing an Excel 2002 spreadsheet into Access 2002 all day. It was simple with prior versions of Office. If any Access 2002 users or developer recieved the message "External table is not in expected format" when importing a 2002 spreadsheet; and you can't figure out the problem. Then today is your lucky day. In order to import the spreadsheet, you must first save the file as a web page. Go to file, save as...,save as type "Web page." Then import the web page into Access 2002. Oh CSV file type works also.
If anyone know a better way please reply with the solution.
James
If anyone know a better way please reply with the solution.
James
Last edited:
