HowardVenable
Technical User
Objective:
Transferring data from one table to the other table.
Problem: DB1 table has many fields (over 50), Runs linearly covering many chapters.
BASE / MAJCOM / YEAR / CH1_4_1 / CH1_4_1_Cost / CH1_4_1_Date
Text ! Text ! Date ! Number ! Currency ! Date
-------------------------------------------------------------
/ CH1_Remarks / and continues on linearly up to chp12
! Text !
_____________________________________________________________
DB2 table has many fields that when filtered out equal each chapter group.
Key ID ) (Foreign ID- Chapter#)
ID Vio / Per / Estimated Cost / Date Estimated / ID SubSec /
Auto# !Number! Currency ! Date ! Text !
Solutions tried:
(1) Querying each record in DB2 filter for each specific chapter
" 1. 4. 1"
Then tried to append each with action query to DB1 Table one at a time. On second action query append -error message "Can't append all the records in append query" MS Access set 0 field(s) to Null due to type conversion failure, ......"
(2) Queried all queries to one to produce table or query. Can only query up to 10 at a time before query becomes too complex. And remains complex if the queries of 10 are queried together.
(3) About to try linking an Excel table to and from Access tables as an Converter. Should work and it would be nice to write a VBA or Sequel program to do it and keep it with in the access DB but I don't have the experience.
I need help from a gurus......Anybody? Please.
Transferring data from one table to the other table.
Problem: DB1 table has many fields (over 50), Runs linearly covering many chapters.
BASE / MAJCOM / YEAR / CH1_4_1 / CH1_4_1_Cost / CH1_4_1_Date
Text ! Text ! Date ! Number ! Currency ! Date
-------------------------------------------------------------
/ CH1_Remarks / and continues on linearly up to chp12
! Text !
_____________________________________________________________
DB2 table has many fields that when filtered out equal each chapter group.
Key ID ) (Foreign ID- Chapter#)
ID Vio / Per / Estimated Cost / Date Estimated / ID SubSec /
Auto# !Number! Currency ! Date ! Text !
Solutions tried:
(1) Querying each record in DB2 filter for each specific chapter
" 1. 4. 1"
Then tried to append each with action query to DB1 Table one at a time. On second action query append -error message "Can't append all the records in append query" MS Access set 0 field(s) to Null due to type conversion failure, ......"
(2) Queried all queries to one to produce table or query. Can only query up to 10 at a time before query becomes too complex. And remains complex if the queries of 10 are queried together.
(3) About to try linking an Excel table to and from Access tables as an Converter. Should work and it would be nice to write a VBA or Sequel program to do it and keep it with in the access DB but I don't have the experience.
I need help from a gurus......Anybody? Please.