MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel data to access


Posted by Steve Clegg on November 15, 2001 6:02 AM

I have a number of "excel" data files
that I would like to transfer to an access
database (yet to be created).

Each excel file consists of a number of tabs which I
would like to transfer to one large access database.
Thanks
Steve


Posted by Jane Naylor on November 15, 2001 6:12 AM

Use File/get external data/import.
You then specify which sheets you wish to import.
Be careful with data types in the excel sheet as these can be misinterpreted in Access then look messed up, so make sure the number or text format etc is correct in Excel.As far as Iknow, you will need to import sheets seperately, first to differnet tables, then in Access combine all the tables into one using append queries.