Recent content by md85

hmmmm....thing is for that part I had defined Public Const DataLocation As String = "C:\Documents and Settings\Alice\Desktop\Database\TestDatabase21.accdb"

Yeah, I think I kind of understand how it can be done from Access; thing is have created a sort of Dashboard in Excel for the front-end so it would definately be better to manage everything from the Excel side of things and leave Access as the back-end. The error I'm getting when UPDATE is run...

Cool, thanks! Will check that out; seems simple enough. Also forgot to add earlier on; the worksheet where the values for the Access table are taken from, has a formulae in the cells which comes up with a value once its applied, so how to paste just the VALUES?

The formatting is applied before the data is pasted in; but thats because I have this worksheet saved and all the cell formatting has been done before-hand;(Without using VBA; it's done by using the right click Format Cells.. option). So the place where the data is being pasted in is a kind of...

Hey all, have been working on designing a new database for work. They have been using Excel for their daily reports and all the data is stored in there, so I decided to have the back-end of the database in Access and the front-end in Excel, so any analytical work can be easily performed once all...