Linking tables to spreadsheets

W

W M

Windows XP Pro
Office XP

I bring data into Access from excel spreadsheets. Periodically, these
spreadsheets are updated and when that happens, I have to delete the tables
in Access and re-import them. Is there a way to have Access link the tables
to those spreadsheets so that when an update occurs I do not need to delete
and re-import all tables? An answer phrased in the newbiest newbie terms you
know would really help because I have hardly any experience with Access.
Thanks to everyone for all the advice they offer in these newsgroups and
thanks in advance to anyone who would like to field my question.

~Wendy
 
G

Guest

hi,
yes you can link the xl files.
file>get external data>link tables...
when the link table dialog box comes up, select file type
as microsoft excel. follow the wizard.
 
M

molsonexpert

W M said:
Windows XP Pro
Office XP

I bring data into Access from excel spreadsheets. Periodically, these
spreadsheets are updated and when that happens, I have to delete the tables
in Access and re-import them. Is there a way to have Access link the tables
to those spreadsheets so that when an update occurs I do not need to delete
and re-import all tables? An answer phrased in the newbiest newbie terms you
know would really help because I have hardly any experience with Access.
Thanks to everyone for all the advice they offer in these newsgroups and
thanks in advance to anyone who would like to field my question.

~Wendy
Click to expand...

from a semi-newbie to a newbie, I would try (on a test database first, of
course) creating a macro that imports the spreadsheet into your database
when run. there's an action called TransferSpreadsheet, and you can
configure parameters for it (e.g. spreadsheet name, table name, etc.). if
desired, you also run a action in the same macro that would delete the
existing table before the import. I think you'd need to make sure this is
really what you want, thoght.

steve.
 
Top