Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
victord
Yak Posting Veteran
64 Posts |
 Posted - 2003-01-22 : 04:40:19
|
| Hi Folks,I am trying to update/append tables in sql server using a table in Access.Below is the query i have written to do this:insert into stahystr2(student_id,acad_period,aos_code,aos_period,seq_no)select t_qlsdat.student_id,t_qlsdat.acad_period,t_qlsdat.aos_code,t_qlsdat.aos_period,t_qlsdat.seq_nofrom stahystr2 join openrowset('Microsoft.Jet.OLEDB.4.0','H:\Registry\t_qlsdat.mdb';'';'', example_valid_data_table)on example_valid_data_table.student_id = stahystr2.student_idorder by example_valid_data_table.student_idThis query gives me the following error :Server: Msg 7403, Level 16, State 1, Line 1Could not locate registry entry for OLE DB provider 'Microsoft Access Driver [*.mdb]'.What could i be doing wrong.Thanks.Vic |
|
|
rihardh
Constraint Violating Yak Guru
307 Posts |
Posted - 2003-01-22 : 04:47:31
|
| Set up a linked server to your Access database and forget the "openrowset" command, just change the FROM clause a little bit (look in BOL under "linked server"). |
 |
|
|
|
|
|
|
|
Openrowset query