View Full Version : not being able to export Excel to Access


bugsy
11-23-2007, 08:30 AM
What can be the reason ?
i'm doing it through a regular "Import Spreadsheet Wizard", and get a message "an error occured trying to import file"
File is not open. Made a copy under a different name; still can't import..

boblarson
11-23-2007, 08:59 AM
can you post the Excel file so we can try it? You might have some blank fields with embedded spaces, or something.

bugsy
11-23-2007, 10:30 AM
says

"Invalid File" (when it try to upload)
whats that about ?

boblarson
11-23-2007, 10:35 AM
If you click on the Manage Attachments button you will see the list of what is allowed. If you want to upload an Excel file (or MDB file) you have to zip it first so that it is a .zip file.

bugsy
11-23-2007, 11:13 AM
uploaded.
(it was a reall tiny file; y zip ?)