Excel Report - Access Records

[Lambi000]

I have an established database that uses a formatted Excel spreadsheet as
it's report. This report goes out to be filled in by various people and,
when it gets back, the data needs to be returned to the Access database. (I
would prefer to do this a host of other ways, but the powers that be want it
this way at present.)

Is there any way I can get the report and the database in sync so that any
changes in either is reflected in the other?

Thanx

 

[Duane Hookom]

You haven't suggested how you have implemented your solution. Are Excel files
sent to others who enter type data into cells? How do you get the new data
back?

The simplest method might be to add a primary key to the Excel file rows.
Then import the Excel file back into your MDB and join to the imported table
to update your Access data.

 

[Lambi000]

Duane,
The spreadsheet "report" is emailed out to a supplier on the outside, who
fills out the required data in the provided cells and emails it back to us.
It is saved with the same file name and in the same folder, replacing the
original.

I am weak in Excel. My problem is the formatting, which has lots of cells
with field descriptions and a few with cells to be filled in. I have used a
"database" within the spreadsheet which references the "report", so when the
report is filled in I can do the ODBC thing and get the data back that way. I
was hoping for some way to just have the two linked so that the spreadsheet
information would be accessible.

I can understand how to incorporate a regular spreadsheet, but when there's
only one record per spreadsheet file, I'm stumped.

 

[Duane Hookom]

You could link to the spreadsheets, use automation, import, copy and
paste,... Whatever you feel comfortable with.

If you have a specific question, feel free to ask.