469,926 Members | 1,807 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,926 developers. It's quick & easy.

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
Nov 13 '05 #1
1 2391
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
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by Scott Tilton | last post: by
9 posts views Thread by Graham | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.