just wondering if anyone knows how to insert about 10 lines of data into an already existing table?

use an Insert Into SQL statement

thats what i figured. my problem is i have a table with 1 row and 12 colomns. what i want to do is add a line 2 with 12 new values. then a third line with different values and so on. is this possible with one sql statement?

I would create a VBA function to collect the values then run the SQL statement. With your values as parameters.