Updating Multiple Access Tables with Single Excel File

[Ken]

Help!

I have a MS Access database made up of a single table. The data updates for
this database comes in the form of a single Excel spreadsheet, which is
imported into the database table.

I need to break-out this single database table, into multiple tables to
better structure the database and reduce the need to input the same data
repeatedly.

What I need to know is, after I break this database up into multiple tables,
will I still be able to update the data in these tables, from the same
single excel file?

If the answer is yes, how would this be accomplished?

Thank you for your help.

//Ken

[Br]

Ken <km******@kc.rr.com> wrote:

Help!

I have a MS Access database made up of a single table. The data
updates for this database comes in the form of a single Excel
spreadsheet, which is imported into the database table.

I need to break-out this single database table, into multiple tables
to better structure the database and reduce the need to input the
same data repeatedly.

What I need to know is, after I break this database up into multiple
tables, will I still be able to update the data in these tables, from
the same single excel file?

If the answer is yes, how would this be accomplished?

Thank you for your help.

//Ken

You'd need to import into a temporary single table and then run some
sort or process that goes through it to split the data into seperate
tables.
--
regards,

Bradley

A Christian Response
http://www.pastornet.net.au/response