Importing from Access

[Stuart Grant]

I have Access 2003 but I am pretty much a newbie. I have a data base program
set up in Excel but have decided that it would be much better in Access. I
want to import the data. I found the commands and imported one worksheet.
Access sets it up as a new table. I would like to import the data into an
existing table. I also want to import the data from several worksheets with
an identical layout into one Access table. The data is not that big. There
are about 10 fields and 300 records .
Is there any easy way of doing this. I cannot get cutting and pasting to
work in Access. I can cut but cannot paste successfully. Can anyone help ?
Stuart

 

[Van T. Dinh]

Link the spreadsheets into your Access database rather than import. These
will appear in your database as Linked Tables.

You can then use Append Queries to insert the rows / Records from the Linked
Tables (one at a time) to your existing Table.

 

[Guest]

Hi Stuart -
Another way to import EXACT Excel databases is this. Make sure that the
first row in each file you are importing is exactly the same and are the
Field Names. Click on First Row Contains Column Headings when you import the
data and the when you click on Next you'll have access to the second option
button - Store in an existing table. I used this a lot when I was transfering
from Excel to Access. When you are just starting this is easier than learning
Append Queries (which you should later learn)

Yours - Dika (Kernow Girl)

 

[Stuart Grant]

Van: Appreciate your jumping in promptly. I tried linking worksheets.
Problem is that each spreadsheet contains other information - headings,
titles, totals etc, not just a compact batch of records, so I don't want
just to copy rows of data but selected data. Access doesn't seem to like
that.
I think I had better go back to Excel and group the data in other sheets.
Thanks for your help anyway.
Stuart

 

[Van T. Dinh]

Before I import/link an Excel spreadsheet into Access, I generally have to
clean up the Excel spreadsheet so that the spreadsheet only contain ONE
heading rows and then data rows. To avoid other problems, I generally need
to check that values in the same column are either all numeric or all text
but not both.