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-21 : 09:25:29
|
| Hi All, I am trying to develop a process that allows a user to update/append tables into sql server from an Access database using a vb gui or front end. Example, The Access table, Table A(field 1,Field 2,Field 3) The Sql table , Table b(field A, Field B, field C) When appending from tablee A to Table B some of the records from Table might fail to be appended or updated, due to various reasons(Errors). I want to be able to capture the records/data that were not appended or updated into a text file, record by record. For example a csv file. |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2003-01-21 : 09:28:24
|
Have you tried an access data project (accessk or access2002)?quote:
When appending from tablee A to Table B some of the records from Table might fail to be appended or updated, due to various reasons(Errors).
How are you appending (cut and paste) or query? If query post it?quote:
I want to be able to capture the records/data that were not appended or updated into a text file, record by record. For example a csv file.
Once you have the query that finds the records that did not append you can use aDoCmd.TransferText or use ADO to output to a csv.Edited by - ValterBorges on 01/21/2003 09:29:52Edited by - ValterBorges on 01/21/2003 09:31:41 |
 |
|
|
victord
Yak Posting Veteran
64 Posts |
Posted - 2003-01-21 : 11:54:48
|
quote:
Have you tried an access data project (accessk or access2002)?quote:
When appending from tablee A to Table B some of the records from Table might fail to be appended or updated, due to various reasons(Errors).
How are you appending (cut and paste) or query? If query post it?[quote]I want to be able to capture the records/data that were not appended or updated into a text file, record by record. For example a csv file.
Once you have the query that finds the records that did not append you can use aDoCmd.TransferText or use ADO to output to a csv.Edited by - ValterBorges on 01/21/2003 09:29:52Edited by - ValterBorges on 01/21/2003 09:31:41[/thanks for the reply. I will be doing the job using a query.e.g 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_id] |
|
|
|
|
|
|
|
|
Access to Sql server