Import wizard

  • Thread starter Thread starter CAM
  • Start date Start date
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.
 
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.
 
Back
Top