Trying to use "Import Spreadsheet Wizard" in Access

Z

znibk

I don't know code so I'm trying to use the Import Wizard in Access to import
Excel Worksheet. I go to the Tables view of Access. I click on "New," Click
on "Import Table," Click "OK" the screen changes so that I may choose the
location of the file I want to Import. I set the "Field Type" to "Excel
Worksheet," find the file and double click on it. The "Import Spreadsheet
Wizard" box appears, I have previously in Excel set the print range so I
Click on "Show Named Ranges," Click "Next," Click "First Row Contains Column
Headers," (which I have previously entered into Access as they appear in
Excel with the format of "Date," and "Text") I Click "Next." Since I want to
put the information on the spreadsheet into an existing table in Access, I
click "In An Existing Table," locate the name of the Access Table, Click
"Next," The next popup menu shows the name of the Access Table I chose and I
click "Finish." I keep getting the same message that an error occurred trying
to import and "The file was not imported."

I have gone back through each of my worksheets and looked at the headings,
looked at the format of the cells; I've been trying to figure this out for
two days, with repeated attempts, any ideas?
 
6

'69 Camaro

Hi.
I keep getting the same message that an error occurred trying
to import and "The file was not imported."

The Spreadsheet Import Wizard won't help you determine what the error is.
To find out, convert the spreadsheet to CSV format and use the Text Import
Wizard instead. For more information, please see the following Web page:

http://www.access.qbuilt.com/html/spreadsheet_imports.html

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
 
C

chrissyb

Hi...
I had a similar situation a few weeks ago. I eventually found out that my
column headings in Excel COULD NOT HAVE ANY SPACES BETWEEN WORDS.
For example Date of Birth needs to be DateofBirth.

That helped me. I hope it's your fix too.
 

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

Top