By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,853 Members | 1,012 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,853 IT Pros & Developers. It's quick & easy.

Updating Multiple Access Tables with Single Excel File

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.