I am trying to read 1000 line items from a file and put them into a Access
Database. Each line item is a seperate column. whats the best way to do this?

The way I know to insert a record to a table is by using
INSERT INTO PersonData2 VALUES (value1, value2, value3)
If I use that I a think I have to declare 1000 variables.

Is there a better way to do this. Please let me know if there is one.