Need Help w/ moving 3K records from Excel '95 to ACCESS '00.

[dandyboy]

I keep track of all receipts that I have had since '97 in an Excel '95 spreadsheet. This Excel '95 spreadsheet has only 3 columns but has 3,000(3K) rows. I tried to move this to an Access '00 database for programming purposes. I found this to be very painful. I had to move highlight the row in Excel '95, Then copy this, Then go to my ACCESS '00 and paste it. I did that for 5 records and I gave up. I tried highlighting some records(and later all records) but it would not allow me to copy and paste more than 1 record at a time.
Any ideas or suggestions on how to do this faster???

 

[SgtJarrow]

Open up your access database, in the menu bar, click Files -> Get External Data -> Import. Change the file type to Excel and navigate to you file....check your field types in the import wizard, etc (I Typically leave the default), and finish the import. Then move/manipulate the data as necessary to have it where and how you want it. The secret to creativity is knowing how to hide your sources. - Albert Einstein

Robert L. Johnson III, A+, Network+, MCP
Access Developer/Programmer