B
Bob Sullivan
Merging excel worksheets into access tables is
straightforward. For best results, make sure your excel
data begins in cell a1, and if creating a new table, you
could use your column headers as field names. If
importing into an existing table, strip out the column
headers for best results.
If you are merging into an existing table, choose File,
External Data, Import Table. Follow the wizard's
instructions so that you will import your excel data.
When the wizard asks if you are importing into a new or
an existing table, select the appropriate one.
Bob Sullivan
Springhouse
straightforward. For best results, make sure your excel
data begins in cell a1, and if creating a new table, you
could use your column headers as field names. If
importing into an existing table, strip out the column
headers for best results.
If you are merging into an existing table, choose File,
External Data, Import Table. Follow the wizard's
instructions so that you will import your excel data.
When the wizard asks if you are importing into a new or
an existing table, select the appropriate one.
Bob Sullivan
Springhouse