Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Subquery in INSERT Statement

Status
Not open for further replies.
chertel

chertel

Programmer
Apr 15, 2002
10
US
I am trying to add records to a table which is located in my ERP Software. I have a simple INSERT statement that works if I manually include the data that I want inserted it works fine...BUT...I have a table that I imported from excel and it want to use this as reference for the data insert. I hope I am being clear here. Basically, I have a excep spreadsheet filled with the info I want to Insert into a table located in my ERP Software. HELP and THANK YOU!!!

-Carla C. Hertel
 
Status
Not open for further replies.

Similar threads

combo
  • Locked
  • Question
SQL data types in CREATE/ALTER TABLE queries 1
Replies
2
Views
2K
combo
combo
Swi
  • Locked
  • Question
Jet Sql Statement - Select Distinct Multiple Columns 1
Replies
4
Views
944
Swi
Swi
C
  • Question
Run-time error '3075': Syntax error (missing operator) in query expression 'Birthday = and Birthmonth ='.
Replies
3
Views
294
OzFoxy
OzFoxy
BugZap13
  • Locked
  • Question
Need help creating a date from two fields to be used in where clause
Replies
5
Views
604
mikrom
mikrom
combo
  • Locked
  • Question
'Wrong property setting' message in query 1
Replies
2
Views
4K
combo
combo

Part and Inventory Search

Sponsor

Back
Top