Transfer Excel Data to Access DB

[cindyredo]

Is it possible to take certain data from an Excel spreadsheet (specific row/column) and then transfer that data to an existing Access db automatically -- meaning upon SaveAs can the data be transferred? Would this be done using a macro within Excel -- this is all new to me, any help would be greatly appreciated.....

This will need to be transferred everytime a new spreadsheet is completed on a specific customer. The company does not want to use Access to capture the data from the beginning, wants their team to continue using the Excel ss.

 

[Pat Hartman]

You would have to create a macro in Excel to run the VBA code necessary to transfer the data from the spreadsheet to the db.

 

[neileg]

Is it possible to link the Excel table to the database? I realise that this is not always possible or appropriate, but it eliminates the need for lots of code.