INSERT INTO

  • Thread starter Thread starter dhstein
  • Start date Start date
D

dhstein

In this code below:

DoCmd.RunSQL "DELETE * FROM tblCostChanges;"

DoCmd.RunSQL "INSERT INTO tblCostChanges SELECT * FROM qryCostChanges;"


Do the fields have to be identical in the query and the table? Same names ?
Same datatypes ? Same sizes? Thanks for any help on this.
 
dhstein said:
In this code below:

DoCmd.RunSQL "DELETE * FROM tblCostChanges;"

DoCmd.RunSQL "INSERT INTO tblCostChanges SELECT * FROM qryCostChanges;"


Do the fields have to be identical in the query and the table? Same names
?
Same datatypes ? Same sizes? Thanks for any help on this.
Click to expand...

The number of fields must be the same. The names don't matter, but by
position they must have the same data type. Size only matters if you might
be attempting to put too large a value (in other words, if field 4 in
qryCostChanges is too big to fit in field 4 of tblCostChanges)
 
Back
Top