running multiple inserts into access

[Chrissirhc]

Hi,

Does anyone know how to do this??? If I have more than one line in the query window it complains.

Thanks,

Chris

 

[IGPCS]

what compalins about what are you talking ?

I will try my best to help others so will others do!!!!!
IGPCS
Brooklyn, NY

 

[Chrissirhc]

Characters found after end of SQL statement" If I put a ; after every SQL statement.

OR

"Missing semicolon ( at end of SQL statement"

If I do include a ;

Any ideas?

Thanks,

Chris

 

[Chrissirhc]

Should have read

"Characters found after end of SQL statement" If I put a ; after every SQL statement.

OR

"Missing semicolon ( at end of SQL statement"

If I do not include a ;

 

[IGPCS]

can you paste one of your sql so i can look at it and try to help you

I will try my best to help others so will others do!!!!!
IGPCS
Brooklyn, NY

 

[Chrissirhc]

insert into table values ('HELLO, 'V', 'HELLO', NULL,"", 0,0, 0.1,"");
insert into table values ('HELLO2', 'V', 'HELLO2', NULL,"", 0,0, 0.1,"");

 

[IGPCS]

after the first hello your missing a '

I will try my best to help others so will others do!!!!!
IGPCS
Brooklyn, NY

 

[Chrissirhc]

thats a typo in my post and not in the actual query.

I guess my real question is. Could you show me how to perform two insert tables in Access please?

 

[Chrissirhc]

I know I can run my queries one by one and they work...

 

[IGPCS]

put the ; only in the end of the second line i think access works like that

or you can try to create the sql thru ms access query builder

I will try my best to help others so will others do!!!!!
IGPCS
Brooklyn, NY

 

[Chrissirhc]

I get an error "Missing semicolon ( at end of SQL statement" when I only put the ; on the last entry. It also highlights the 2nd entry to indicate where it is expecting the ;

Have you done multiple inserts in Access using the SQL view before and know it is possible?

Thanks a lot,

Chris

 

[PHV]

The access's query window is for single instruction, period.
You may consider VBA code with either the DoCmd.RunSQL or CurrentDb.Execute methods.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[IGPCS]

oh i thought you are talking about vba code i dont konw why but thats what i thought so PHV is 100% good advise use the VBA and queries is only for single

I will try my best to help others so will others do!!!!!
IGPCS
Brooklyn, NY