SQL Insert Queries

[chertel]

Hi-

I am writing an insert query through Microsoft Access and I am having trouble on how to get more than one row updated at a time. Here is the statement that I have working now.

INSERT INTO F4104
(ivan8,ivxrt,ivitm,ivexdj,iveftj,ivcitm,ivdsc1,ivaln,ivlitm,ivaitm,ivurdt,ivurat,ivurab,ivuser,ivpid,ivjobn,ivupmj,ivtday)
VALUES
(10211, 'CU', 11100, 110365, 102091, ' 1145481', ' ALFENTA AMPS 20mL CII 5/BX ', ' 1145481', ' 11098-0060-20 ', ' 06020/2832 ', 0, 0, 0, 'CHERTEL', 'EP4104', 'CARLA', 102094, 162228)

I want to add another row to the table. I have tried using AND and then continueing with the values and this does not work. HELP and THANK YOU!!

-Carla C. Hertel

 

[jhall156]

It's pretty unusual to want to hard-code all the values in an INSERT statement. Is this information going to ultimately come from a form the user is entering information into? JHall

 

[chertel]

I am trying to take an excel table with all the info that needs to be added to my ERP system Table. All of these values need to be inserted into this table. I took the info from excel exported it, messaged the data so it was formatted correctly and then pasted it into this insert statement. I have it working for one record but I have hundreads of records that need to be added to this table. I don't know if you can answer this either but is there a way to tell the insert statement to find my table in access and use that as the infomation to be used to insert into my ERP system Table? Any help here would be great! Thank you.
-Carla C. Hertel