Access and Excel

D

Dip

Hi Everyone:

I am trying to use 2 to 3 key cells in Excel sheets to be the primary keys
in an Access database. How do I save these Excel sheets in the Access. Please
help.

Dip
 
P

pietlinden

Hi Everyone:

I am trying to use 2 to 3 key cells in Excel sheets to be the primary keys
in an Access database. How do I save these Excel sheets in the Access. Please
help.

Dip
Click to expand...

Import them? Try TransferSpreadsheet... or if you want proper
control, create the table beforehand and then append the records from
a linked spreadsheet.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell data entering slow! 0
Update several ppt documents from a single excel file 0
Continues to move to the right 0
Excel --> Word 4
Visio: copy text of a master shape to User-define Cells (Variable) 0
sqlite-odbc write conflict 2
Objects and Security 1
Merging from an Excel file with graphics 1

Top