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.
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.
If you think someone helped you, click on the "* Add Reputation" as a way to say thank you.
If your problem is solved, go to Thread Tools and select Mark This Thread Solved
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/
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Cross-posted: https://stackoverflow.com/questions/...lues-to-access
Rory
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
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
Last edited by alansidman; 07-01-2020 at 04:17 PM.
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.
Last edited by saravnepali; 07-04-2020 at 05:52 PM.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks