I am reading a text file as input and inserting some data into a table. I have a while loop that reads a record, and then inserts into the table, but the process is incredibly slow. I thought there was a way to do something like:
insert into table
values ("a","b","c")
("d","e","f")
("g","h","i")...etc.
This doesn't seem to work in Access. Is there a better way to do this?
insert into table
values ("a","b","c")
("d","e","f")
("g","h","i")...etc.
This doesn't seem to work in Access. Is there a better way to do this?