refreshing imported data

[chummy via AccessMonster.com]

I am creating an application that imports an excel spreadsheet into a
database during the setup process. The spreadsheet has hyperlinks to
documents and other information and will be what is going to be maintained.
If any changes occur the person does not have to go into the database but
will make the modifications in the spreadsheet. Is there a code that can
refresh the database to show any changes that have been made to the excel
spreadsheet? Thanks for your help.

 

[Guest]

Easily, No. When you import a spreadsheet into an existing table, it
replaces the content of the table with that of the spreadsheet. It is
possible to do what you are trying to do, but it will be more complicated.
How you do it will depend on information you have not provided.

The easiest way would be to reimport the modified spreadsheet; however, that
would only be an option if no changes to any of the imported data are made in
the database. If changes are made in the database and in the spreadsheet
(which from a design perspective should never happen), you have created a
monster. You will have no way of knowing which data are correct. If you
have done it correctly, and data is changed only in the spreadsheet, then the
method I would use would be to link to the spreadsheet and update only the
data that has been modified.

 

[chummy via AccessMonster.com]

Any changes will be made to the spreadsheet and spreadsheet only. Can anyone
tell me how I would go about updating the database? If a change is made to
the spreadsheet, does the database detect it and make the changes? I don't
think this is possible.

What I want to be able to do is to automatically refresh the database once a
user opens it up. Any help or guidance would be appreciated! Thanks

Easily, No. When you import a spreadsheet into an existing table, it
replaces the content of the table with that of the spreadsheet. It is
possible to do what you are trying to do, but it will be more complicated.
How you do it will depend on information you have not provided.

The easiest way would be to reimport the modified spreadsheet; however, that
would only be an option if no changes to any of the imported data are made in
the database. If changes are made in the database and in the spreadsheet
(which from a design perspective should never happen), you have created a
monster. You will have no way of knowing which data are correct. If you
have done it correctly, and data is changed only in the spreadsheet, then the
method I would use would be to link to the spreadsheet and update only the
data that has been modified.

I am creating an application that imports an excel spreadsheet into a
database during the setup process. The spreadsheet has hyperlinks to

[quoted text clipped - 3 lines]

refresh the database to show any changes that have been made to the excel
spreadsheet? Thanks for your help.

 

[Guest]

The database will not detect any changes made to the spreadsheet. You are
going to need to write procedures to accomplish this. Doing it when the
database is first opened may be problematic if it is a multi user system,
because the data would be refreshed each time another user opened the
database. There will also be a problem if a user has the spreadsheet open
when the database is opened, but in any case, the concept is this.

If the data only changes in the spreadsheet, the easiest way to do it would
be to import the spreadsheet each time you open the database. Since all
changes happen in Excel, it is okay to replace what is in the database. You
can do this in whatever your stat up routine is. If you have a form
identified to open, then run the TransferSpreadsheet method in the Load event
of that form. If you are using an Autoexec macro, add a line to do the
transfer there.

Any changes will be made to the spreadsheet and spreadsheet only. Can anyone
tell me how I would go about updating the database? If a change is made to
the spreadsheet, does the database detect it and make the changes? I don't
think this is possible.

What I want to be able to do is to automatically refresh the database once a
user opens it up. Any help or guidance would be appreciated! Thanks

Easily, No. When you import a spreadsheet into an existing table, it
replaces the content of the table with that of the spreadsheet. It is
possible to do what you are trying to do, but it will be more complicated.
How you do it will depend on information you have not provided.

The easiest way would be to reimport the modified spreadsheet; however, that
would only be an option if no changes to any of the imported data are made in
the database. If changes are made in the database and in the spreadsheet
(which from a design perspective should never happen), you have created a
monster. You will have no way of knowing which data are correct. If you
have done it correctly, and data is changed only in the spreadsheet, then the
method I would use would be to link to the spreadsheet and update only the
data that has been modified.

I am creating an application that imports an excel spreadsheet into a
database during the setup process. The spreadsheet has hyperlinks to

[quoted text clipped - 3 lines]

refresh the database to show any changes that have been made to the excel
spreadsheet? Thanks for your help.