PDA

View Full Version : Database Importing


unclesams
Jul 7, 2007, 05:47 PM
Ok - question

I have 800 databases (Excel) - price lists of clothing companies and I want to import them into access is this possible without having to type the products one by one. I need a way of importing a struture and letting this info feed into my access database including pics and prices.

Thanks RICH

benn11
Jul 11, 2007, 03:59 AM
Here is a good paper on converting excel into access >> (http://databases.about.com/od/tutorials/ss/exceltoaccess.htm)

ScottGem
Jul 11, 2007, 06:28 AM
Within Access create a table to hold your lists, then use the Import facility to add the records from the spreadsheets to your table. For mosre specifics plerase let us know what version of Office you have.