Import wizard

C

CAM

Hello,

I am trying to use the import wizard in Access, but I am running into
problems. I am unable to get wizard to import an Excel spreadsheet. The
spreadsheet has password protection, I disable it, but still can't import.
I do have macros in the workbook and is password protected, but the macros
are for printing so I don't think this is the problems. Can anyone tell me
what else can it be that I am unable to import? Thank you in advance.
 
F

fredg

Hello,

I am trying to use the import wizard in Access, but I am running into
problems. I am unable to get wizard to import an Excel spreadsheet. The
spreadsheet has password protection, I disable it, but still can't import.
I do have macros in the workbook and is password protected, but the macros
are for printing so I don't think this is the problems. Can anyone tell me
what else can it be that I am unable to import? Thank you in advance.
Click to expand...

Did you try importing using code?
Look up the DoCmd.TransferSpreadsheet method in VBA help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Importing Excel spreadsheet into Acces 1
Import Excel Spreadsheet 1
Import Spreadsheet missing field 8
Import Wizard 3
I can not import Excel Spreadsheets 3
Weird Excel import problem (A2003) 1
Import wizard missing 2
Re-using Saved Imports from a button on a form 10

Top