I'm trying to import an Excel spreadsheet into an exsiting table..

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

Guest

Hi, when i try to export my Excel spreadsheet into an exsiting table I get an
error message that the data has not imported. I can create a new table with
the information but not into an exsiting one. I have had this problem since I
stared using Access. I am not an expert and need some help Please...

Thanks
Robin
 
Robin

"Import" or "export"?

One way you can get data from an Excel spreadsheet into a table in Access is
to open an Access .mdb file and link to the Excel spreadsheet. With this
approach, you don't have to move the data (import or export), you can just
see it.

What are your intentions? What do you want to do with the data once you can
see it?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Jeff, I don't know where Robin went, however I had the same error, I had to
create a new table, couldn't use the one that was already set up in the
template that I downloaded from Microsoft Office Templates.

My question does the existing table (in the access database) have to have
the same column headings as the excel spreadsheet you are trying to import?
I have a membershp databased that is overgrowing the excel spreadsheets that
I currently use (process, copy, paste, etc).
 
Kathy

Without a lot more detailed information to go on, be aware that you can link
to Excel spreadsheet without importing them.

And if you must import the data (i.e., create a table in Access that
duplicates the data in Excel), then consider importing the raw Excel data,
followed by using queries to parse that raw data from what is probably not a
well-normalized structure (Excel spreadsheet) into your more permanent (and
better-normalized) Access tables.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
I know I can link the spreadsheet, but this table within the database would
be updated every month, it is a membership data base. I am tring to get away
from using the Excel as I have run into errors (merging thru word, form
letters, labels, etc.) and believe the data is too large and needs to be in a
database.

Again I captured a template and when I tried to import the excel spreadsheet
to it it wouldn't so I ended up linking it, but was curious why it wouldn't
import...do the column headings have to be labeled the same for it to import.
 
Kathy

If you import "into" a given table structure, yes, you'll have to match up
(or tell it how to match up). But you can also import an Excel spreadsheet
into it's own (new) table.

I still recommend taking the time to normalize your data BEFORE you create
an Access table and BEFORE you decide how to store data originating in
Excel. Excel data, by the nature of the tool, is rarely well-normalized.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top