Update data from Excel to Access

Hi,

I have a excel spreadsheet.

I need to regularly update the information from the excel to access.

How to I add / copy the information in excel to existing access table.

Probably the easiest way is to format your Excel Table to look like an Access table, then instead of uploading, link it and whenever you make any changes to the Excel table they are concurrently updated in the link so that it appears in Access exactly the same.

https://www.techrepublic.com/article...cess-database/

Cross-posted: https://stackoverflow.com/questions/...lues-to-access

Hi Alansidman,

Thanks for your reply.

The issue I have is I am looking at getting the value on the access independent of the excel workbook. As I don't want to have issues if the excel file is moved or deleted etc.

Ok. Then you can use VBA and Docmd.TransferSpreadsheet

There are lots of tutorial videos on how to implement this. Just google DoCmd.Transferspreadsheet

Originally Posted by alansidman

Ok. Then you can use VBA and Docmd.TransferSpreadsheet

There are lots of tutorial videos on how to implement this. Just google DoCmd.Transferspreadsheet

Thanks

My preference is VBA excel as I have several other vba subroutine

Is it possible to call it from Vba excel

https://www.exceltip.com/import-and-...oft-excel.html

https://www.onlinepclearning.com/exp...cel-to-access/

However, it is much simpler importing from Access VBA

Thanks alansidman

The information was very useful.

Specially, https://www.onlinepclearning.com/exp...cel-to-access/ is literally a gold mine, so much to take from it.

It worked perfectly as intended, to import and export data to access.

Only issue I had was I couldn't get it to append / delete the data.

It shows an error and I couldn't figure out why.

Any ideas will be greatly appreciated

I have added the excel file here The system would not allow me to upload the database file so I have only got the screen shot of it and as a zip file.

Without looking at the DB and Sheet, what this error message is telling you is that you have one data type for one or more of the fields in Access and a different data type for the same fields in Excel. They need to be the same.