tables

[ladyhawkrose]

hello im designing a simple database. Im having trouble importing excel
sheets into the exsisting table. My goal is to create one table with all of
my products instead of multiple tables. Any advise would be helpful, as you
can see im a real newbie at this
thanks

 

[Vincent Johns]

hello im designing a simple database. Im having trouble importing excel
sheets into the exsisting table. My goal is to create one table with all of
my products instead of multiple tables. Any advise would be helpful, as you
can see im a real newbie at this
thanks

I think the easiest way (using a COPY of your Excel spreadsheet to do
this) is to create a new worksheet in the Excel file, enter the field
names into the tops of the columns (A1, B1, C1, &c.), and copy the data
that you want to import into Access to that new worksheet, underneath
the column headings. Insert an extra column, if you wish, to identify
the worksheet (= the product) to which the data belong. Check the
combined list to verify that the contents look OK.

Having done so, and since there is nothing else on this new worksheet,
you can easily import the whole mess into Access via the File --> Get
External Data --> Import... facility.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.