Query inserts wrong data in the table

jeudi 30 avril 2015

Hi Guys

I am writing the following query to insert data in tblpostroom from another table. Both the tables have same field names like Date1,582,1810.

Now If I run the following query then in the fields 582,1810 of tblpostroom , the data gets stored 582,1810 respectively for all the records. But in actual fields 582 and 1810 store different data.

Code:

INSERT INTO tblpostroom ( Date1, 582, 1810 )
SELECT Date1, 582, 1810
FROM Sheet1;

I think I am doing something wrong in the query.Can anyone please help me to resolve this problem?
Query inserts wrong data in the table

0 commentaires:

Enregistrer un commentaire

Labels