I'm looking for a VBScript that takes every record in a specified Excel worksheet called Service Site Matrix.xls, replacing existing data in a table called Data in an Access database called sitematrix.mdb, essentially taking the entire worksheet and replacing the table in the database as is.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Export Excel Worksheet to Replace Access Table
- Thread starter dskelley
- Start date
- Thread starter
- #2
You would probably do better in the VBScript forum (forum329) as this forum is for VB5/6
________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first
For tsunami relief donations
'If we're supposed to work in Hex, why have we only got A fingers?'
for steam enthusiasts
________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first
For tsunami relief donations
'If we're supposed to work in Hex, why have we only got A fingers?'
for steam enthusiasts
- Status
Similar threads
- Locked
- Question