Replace all tbl records with new data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have tblDN and tblDNRawData. tblDN only has [DNNumber]. tblDNRawData has
[Number] and a few other records.... Via VB I would like to:

1) delete all of the records in tblDN's DNNumber
2) take all of the data in tblDNRawData's Number and push into tblDN's
DNNumber

Thanks for your help!
 
CurrentDb.Execute "delete * from tblDN", dbFailOnError
CurrentDb.Execute "insert tblDN (Number) select Number from tblDNRawData",
dbFailOnError
 
Private Sub FixDN_Click()
CurrentDb.Execute "delete * from tblDN", dbFailOnError
CurrentDb.Execute "insert tblDN (Number) select Number from tblDNRawData",
dbFailOnError
End Sub

Returned:
Run-time error '3134: Syntax error INSERT INTO statement.

Sergey Poberezovskiy said:
CurrentDb.Execute "delete * from tblDN", dbFailOnError
CurrentDb.Execute "insert tblDN (Number) select Number from tblDNRawData",
dbFailOnError


Rod said:
I have tblDN and tblDNRawData. tblDN only has [DNNumber]. tblDNRawData has
[Number] and a few other records.... Via VB I would like to:

1) delete all of the records in tblDN's DNNumber
2) take all of the data in tblDNRawData's Number and push into tblDN's
DNNumber

Thanks for your help!
Click to expand...
Click to expand...
 
Rod,

just add "into" into the second statement:

CurrentDb.Execute "insert INTO tblDN (Number) select Number from
tblDNRawData", dbFailOnError

when I wrote the code I was just working in SQL Server where INTO is
optional :-)

Rod said:
Private Sub FixDN_Click()
CurrentDb.Execute "delete * from tblDN", dbFailOnError
CurrentDb.Execute "insert tblDN (Number) select Number from tblDNRawData",
dbFailOnError
End Sub

Returned:
Run-time error '3134: Syntax error INSERT INTO statement.

Sergey Poberezovskiy said:
CurrentDb.Execute "delete * from tblDN", dbFailOnError
CurrentDb.Execute "insert tblDN (Number) select Number from tblDNRawData",
dbFailOnError


Rod said:
I have tblDN and tblDNRawData. tblDN only has [DNNumber]. tblDNRawData has
[Number] and a few other records.... Via VB I would like to:

1) delete all of the records in tblDN's DNNumber
2) take all of the data in tblDNRawData's Number and push into tblDN's
DNNumber

Thanks for your help!
Click to expand...
Click to expand...
Click to expand...
 
Great! Thanks much!

Sergey Poberezovskiy said:
Rod,

just add "into" into the second statement:

CurrentDb.Execute "insert INTO tblDN (Number) select Number from
tblDNRawData", dbFailOnError

when I wrote the code I was just working in SQL Server where INTO is
optional :-)

Rod said:
Private Sub FixDN_Click()
CurrentDb.Execute "delete * from tblDN", dbFailOnError
CurrentDb.Execute "insert tblDN (Number) select Number from tblDNRawData",
dbFailOnError
End Sub

Returned:
Run-time error '3134: Syntax error INSERT INTO statement.

Sergey Poberezovskiy said:
CurrentDb.Execute "delete * from tblDN", dbFailOnError
CurrentDb.Execute "insert tblDN (Number) select Number from tblDNRawData",
dbFailOnError


:

I have tblDN and tblDNRawData. tblDN only has [DNNumber]. tblDNRawData has
[Number] and a few other records.... Via VB I would like to:

1) delete all of the records in tblDN's DNNumber
2) take all of the data in tblDNRawData's Number and push into tblDN's
DNNumber

Thanks for your help!
Click to expand...
Click to expand...
Click to expand...
 
Might consider using SELECT DISTINCT to avoid duplicates (if that's an
issue), even though OP did say "..all the data.." :-)

HTH,


Sergey Poberezovskiy said:
Rod,

just add "into" into the second statement:

CurrentDb.Execute "insert INTO tblDN (Number) select Number from
tblDNRawData", dbFailOnError

when I wrote the code I was just working in SQL Server where INTO is
optional :-)

Rod said:
Private Sub FixDN_Click()
CurrentDb.Execute "delete * from tblDN", dbFailOnError
CurrentDb.Execute "insert tblDN (Number) select Number from
tblDNRawData",
dbFailOnError
End Sub

Returned:
Run-time error '3134: Syntax error INSERT INTO statement.

Sergey Poberezovskiy said:
CurrentDb.Execute "delete * from tblDN", dbFailOnError
CurrentDb.Execute "insert tblDN (Number) select Number from
tblDNRawData",
dbFailOnError


:

I have tblDN and tblDNRawData. tblDN only has [DNNumber].
tblDNRawData has
[Number] and a few other records.... Via VB I would like to:

1) delete all of the records in tblDN's DNNumber
2) take all of the data in tblDNRawData's Number and push into
tblDN's
DNNumber

Thanks for your help!
Click to expand...
Click to expand...
Click to expand...
 
Back
Top