Importing excel data into already defined access database table

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

Guest

Hi,

I am a new user to Access. I am using Access 2003. I have created a
database with one form(Meetings form) and an associated subform(participants
form). Along the same lines, I have two tables, a meetings table and a
participants table that I write to. There is a one to many relantionship b/w
these tables. Previously, I used to use a spreadsheet to capture all this
data. Now, I am trying to figure out, is there a way to import existing data
on my spreadsheet into these two tables. These two tables currently have
some info that I have already put in them. So, I would like to transfer the
excel spreadsheet data into the Access tables instead of manually typing all
this stuff in. Is there a way to do that? Thanks in advance.
 
Assuming this is a one-time thing, I would:
1) use File>GetExternalData>Import and create a new (temportary) table
containing your Excel data.
2) create 2 append queries that would transfer data from that temp table to
your 2 Access tables.

This gives you greater control over what data goes where as opposed to
trying to import from Excel to your new tables directly (which might be
possible depending on your data but is likely to be problematic in any
case).

HTH,
 
Back
Top