Still having problems importing Excel 2003 into Access 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm importing create a new table in access by importing a spreadsheet from
Excel 2003 using the Wizard.

My steps from Access 2003 database view
I chose File
Import
then I went to the path where the spreadsheet was located.
I clicked on the name of the file and then nothng happens.

When I use the same procedure and try and import a table from another table
in another database, it works fine, and the wizard clicks in and everything
transfers like a breeze.

It seems like the wizard is not starting when I choose another format than a
database table.

Most of my other wizards in my Access 2003 are working the way they should
but I did notice when I used a tutorial and tried to create a contacts
database, the wizard would not function.

I'm tried different things, such as connected a blank database on my hard
drive to a spreadsheet on my hard drive and also connected to shared drives,
thinking that might be the problem, but it still doesn't work.

I have Jet 4.0 Service Pack 8 installed on my computer and my security
setting set to medium. I've switched it to low and still the same problems.

Thanks for taking the time to read my post.

donna
 
Hi Donna,

Have you installed Service Pack 1 for Office 2003? If not, you should do
so. (To check, use the Help|About menu command; the version information
in the About dialog will end with "SP1" if the service pack has been
installed.

If that doesn't fix it, the next thing I'd try is to re-register the
following files:

ACCWIZ.DLL
msexcl40.dll (Excel)
msxbse40.dll (dBase)
mspdox40.dll (Paradox)
mstext40.dll (Text, CSV, tab-delimited))

To re-register a DLL file,

1) Locate it (usually all these are in the Windows\System32 or
WINNT\System32 folder).

2) Locate the file regsvr32.exe.

3) Drag the DLL file's icon onto the regsvr32.exe icon.
 
Back
Top