Kalyan Ganesan
Programmer
I have imported a table into MS Access from Excel.its called Sheet1
I have a query below
INSERT INTO LOAN_LIST ( NEW_LOAN_NUMBER,OLD_LOAN_NUMBER )
SELECT TOP 100 Sheet1.[ACCT_NBR] AS NEW_LOAN_NUMBER,Sheet1.[V_Acct_Nbr] as OLD_LOAN_NUMBER
FROM Sheet1;
for some reason it doesnt insert the first column ACCT_NBR into Loan List table..when i just run this query
SELECT TOP 100 Sheet1.[ACCT_NBR] AS NEW_LOAN_NUMBER,Sheet1.[V_Acct_Nbr] as OLD_LOAN_NUMBER
FROM Sheet1;
it does pull two columns data.
there are no triggers or any constraint in the linked table Loan_List
what could be wrong here?
I have a query below
INSERT INTO LOAN_LIST ( NEW_LOAN_NUMBER,OLD_LOAN_NUMBER )
SELECT TOP 100 Sheet1.[ACCT_NBR] AS NEW_LOAN_NUMBER,Sheet1.[V_Acct_Nbr] as OLD_LOAN_NUMBER
FROM Sheet1;
for some reason it doesnt insert the first column ACCT_NBR into Loan List table..when i just run this query
SELECT TOP 100 Sheet1.[ACCT_NBR] AS NEW_LOAN_NUMBER,Sheet1.[V_Acct_Nbr] as OLD_LOAN_NUMBER
FROM Sheet1;
it does pull two columns data.
there are no triggers or any constraint in the linked table Loan_List
what could be wrong here?