sinchronize access table and xls sheet

[luca90]

I use the tipical ADO code to update a Acces table with 8 fields.
In c:\mydir\ have a workbook with sheet_01
The sheet have 8 columns with the same property of Acees table.
How to sincronize table and sheet during the table is updating via ADO?
Hope i am be clear:-)

[JayCR]

I have done this recently where I export the contents of the access database, into a spreadsheet, is this the sort of thing you want? or are you wanting the values to be taken from a spreadsheet and put into the database?

[luca90]

I have done this recently where I export the contents of the access database, into a spreadsheet, is this the sort of thing you want? or are you wanting the values to be taken from a spreadsheet and put into the database?

in effect...
If i insert a value in Access Table automatically update the cell in sheet...

[JayCR]

I have recently done a method whereby, in VB6, you can click a button and it exports the records to a spreadsheet. as for automation, I suppose you could run the application to check with SQL for changes to the database, I can find you some code where it will export them all to the spreadsheet?

Take a look HERE which is Si's tutorial on automating excel. I havent yet found a way to ammend the data in the spreadsheet, but can create new ones, Si might be able to help with it if we cannot find anything online.

Come to think of it, I dont know if you can just ammend one single line in the spreadsheet with one line out of the database, unless there is a way to do it with an array, but there are ways you can open an existing document, and then just rewrite all the data over it, to an extent that may work, as you wont have to worry about saving multiple copies.

[TysonLPrice]

Not sure what you are doing with the spreadsheet but if you just want it updated to reflect the database has when you open it you can set up the spreadsheet with access as the external data source and it will be updated each time you open it.