I am trying to import several Excel worksheets (different workbooks) into an Access Database. The option to add the data to an existing table is greyed out. I don't understand why. The columns in each table are exactly the same.
I just installed Office 2000. I converted the original database (created in Office '97)because I got a message saying I couldn't change the objects of the database unless I converted it. The spreadsheets were created in Office '97. Is that what the problem is? What can I do to add those spreadsheets to an existing table in Access?
I just installed Office 2000. I converted the original database (created in Office '97)because I got a message saying I couldn't change the objects of the database unless I converted it. The spreadsheets were created in Office '97. Is that what the problem is? What can I do to add those spreadsheets to an existing table in Access?
