How to import excel files into access

[Jdenton98]

I am using the Access Template "Contact management database". It is at
http://office.microsoft.com/en-us/templates/TC010178391033.aspx?CategoryID=CT061996291033.
I want to take an existing Excel contact file and import it. Can I do that
without having to individually entering the contact infromation?

 

[Brian L]

I would imagine that as long as your excel spreadsheet follows the same data
schema of the table, you should be able to import the table ( file, get
external data ) and import it. Then use an update query to add that data to
the destination table.

 

[John Vinson]

I am using the Access Template "Contact management database". It is at
http://office.microsoft.com/en-us/templates/TC010178391033.aspx?CategoryID=CT061996291033.
I want to take an existing Excel contact file and import it. Can I do that
without having to individually entering the contact infromation?

Depends on how the data is laid out in the spreadsheet. I'd start by
using File... Get External Data... Link to link to the Excel
spreadsheet; you should then be able to construct one or more Append
queries based on this linked file, to populate the Access tables.

I don't have Contact Management installed (nor of course your
spreadsheet) so I can't be very specific, but you will need to somehow
map the fields in Excel to the corresponding fields in the Access
table or tables. This might require one or more queries.

John W. Vinson[MVP]