Search results for query: *

Thanks pwise - sorry for sounding stupid but do you mean i would use that code in access to overwrite one spreadsheet with the other? Would this be using a macro?

Thanks for your reply hjoldstein. When i use the spreadsheet as a linked table shoudl i be able to clear it down using a delete query? When i try i get the error: Deleting data in a linked table is not supported by this ISAM. (Error 3617)

Hi, my database imports data from a spreadsheet into a temporary access table. When finished with the temporary access table i use a macro to clear down the table but i also need to be able to clear down the data in the external spreadsheet, from access, if possible. This is because a scheduled...

Hi, i have an access (2002) form that pulls in allocation numbers & details for clothing allocations for new staff who will require safety clothing items for their job. when new employee posts are imported into the db they are checked to see if their posts require clothing. this works ok...

Hi, just wanted to thank both lbass & kskid for taking the time out to help me. Lbass your solution worked a treat, many thanks.

hi, this is my 1st post so please excuse any mistakes i make. I have a crystal 10 report querying oracle 10g db. the report counts & details number of claims made for school meals, grouped by benefit type the guardian receives, then grouped by benefit office for each benefit type. There may be...