Import Partial Excel File into Database

[AndrogynyRocks]

Hello everyone,



I have created a database with approximately 30 columns, 1st column being a primary key. At the end of the database there are 5 columns. We will call them VWXYZ.

One of my users wants to be able to update VWXYZ via importing an Excel document to the existing table. He does NOT want fields 1-25 updated. He is editing his Excel document to only include the primary key and then VWXYZ with the same exact column names. When he imports, it sets 2-25 to blank and updates VWXYZ to the updated information.

How can he import an Excel document that only updates VWXYZ?

[June7]

The import wizard does not update existing table data, it will create a new table or append records to table.

If the Excel table structure is suitable, can set up a link to the worksheet then use the linked 'table' as data source to update Access table.

Otherwise, will need VBA code.

[AndrogynyRocks]

Ok, this user needs to import Excel data multiple times a day. What VBA code can be used? Can I get an example?

The import wizard does not update existing table data, it will create a new table or append records to table.

If the Excel table structure is suitable, can set up a link to the worksheet then use the linked 'table' as data source to update Access table.

Otherwise, will need VBA codej.

[June7]

Can't offer 'one size fits all' code. The code will be specific to your situtation. Here is one example http://forums.aspfree.com/microsoft-...le-413493.html

Google: Access import Excel