Recent content by Bigschnoz

Sorted this using a bit of Excel VBA code. A bit of testing for the existence of data in cells, utilisation of ADO and a bit of SQL. Worked well with about 6 breaks where a database didnt exist. It is a bit rough and lacks finesse but worked really well :D Sub TestCells() ' Main start code to...

As described above Hopefully deselecting the highlighted boxes will remove the query overhead from the final spreadsheet. https://docs.google.com/open?id=0B8iICXcLMCYmSXlPbzZJWlliY0U

hi Vilarestal There is an option in the dataquery tool not to retain the query details, (see following post) I am hoping this does what it says on the tin and ensures that once the data has been imported into the relevent cell the query disappears and there is no overhead created.

It would appear that the simplest approach may be to import the necessary data into Excel then link to the main salesforecast database. I have fiddled with a macro in Excel to extract the data I require and drop it in the cell adjacent to the file path of each of the databases I need to...

Sorry it is my first posting and after initially posting in tables it was recommended I put in vba, unfortunately I am not aware of a means of moving the initial thread and was unsure if I should delete the initial thread.

Re Pat's reply in tables thread, yes I agree wholeheartedly that the architecture of this applications database(s) is maddening and nonsensical. The individual databases per job hold some line level data which could simply be held in a single table and archived once in a while if size became an...

Thanks Brumster, I will take a look at it :)

Thanks for reply. Unfortunately I have no control over the data structure as it is built into a proprietary application we use and I am sure they wont modify the "Noddy" structure any time soon. I am only looking to extract a small amount of data from each of the individual databases therefore...

Firstly I must admit to being extremely weak in terms of Access ability. I am looking to build a sales forcast tool (front end may yet be access or excel). The original data comes from 3 sources which are linked comprise the bulk of the data I need with one exception. I need to break down...

Many thanks for your comments guys. The data file structure is as shown below. Setting up an initial data extract as a batch process would be useful as a starting point but there will be an ongoing update issue as each new job creates a new database and this will need periodically including in...

Firstly I must admit to being extremely weak in terms of Access ability. I am looking to build a sales forcast tool (front end may yet be access or excel). The original data comes from 3 sources which are linked comprise the bulk of the data I need with one exception. I need to break down the...

Hi Folks, I have tinkered a little with Access / Excel VBA in the past but the little I learned has disappeared through beer or old age :). I am currently looking to put together a sales forecasting tool which combines links to a spreadsheet order book, Sage 50 and a piece of production software...