Append Query Help--Auto populate a table

[joseph1111]

I need to enter in a large set of records in a database and hope there is an easy way using a query. I have to enter in rows such as A1,A2, A3 through A142. What formula can I use to say to add rows A1 through A142? I've tried several different combinations to no avail.

Thanks for any help.

 

[Golom]

Not really enough information to make a recommendation.

Where are the data now?

How have you tried to "enter rows"?

Can you provide a more complete description of your problem?

 

[PHV]

Play with the AutoFill feature of Excel and then copy/paste to access.

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