Whats wrong with my query

[Kirtap]

Hello,
I had a question. Is there anything wrong with this query?

INSERT INTO Assets(Asset_ID, GPCL_Asset_ID, Asset_Type, Manufacturer, Model, Serial_Number, Description) VALUES(213,'E674',38,171,'37250-00','006631','E674 37250-00 006631 EMC Lab B28'),(214,'E253',255,285,'37250-00','006663','E253 37250-00 006663 EMC Lab');

I have it stored in a variable called Asset_SQL.

The values without single quotes are integer datatypes

In VBA, I am trying to insert to insert multiple values in one query into a table in a database. Unfortunately, when I try to execute it, I get a message stating Run-time error '3137': Missing semicolon (; )at end of SQL Statement.

I tried DoCmd.RunSQL Asset_SQL and I also tried CurrentDb.Execute Asset_SQL

I apologize if this is the wrong section, but I figured maybe something was wrong with my query maybe?



Someone said get rid of the VALUES part, but that just gave me a message saying my INSERT was wrong.

Thank you in advance,
Kirtap

[pbaldy]

Hello,
I had a question. Is there anything wrong with this query?

Yes, with a VALUES clause you can only insert a single record.

[Kirtap]

Thanks!

How can I make it so it enters multiple records in one statement? Or is this not possible?

Edit: Somehow the sql statement got truncated when I copied it. My apologies this is what the sql statement originally looked like.
INSERT INTO Assets(Asset_ID, [GPCL_Asset_ID], [Asset_Type], [Manufacturer], [Model], [Serial_Number], [Description]) VALUES(213,'E674',43,170,'37250-00','006631','E674 37250-00 006631 EMC Lab B28'),(214,'E253',255,285,'37250-00','006663','E253 37250-00 006663 EMC Lab');

[pbaldy]

From a table, sure:

INSERT INTO...
SELECT...
FROM...
WHERE...

If you're in VBA, you should be able to run the SQL twice, each with a different set of values.

[Kirtap]

I see. So I do need to run more than one sql statement.
Anyhow, thanks! I guess consider this solved.

[pbaldy]

No problemo.