Search results

Thanks Woo Hoo ! Now I can finally get a coffee in peace Many thanks for your help

Hi All I am exporting a series of queries from my database to Excel as part of a report. Easy stuff using the TransferSpreadsheet Method. Now the boss wants some of these queries displayed together on a singleworksheet sheet, and some on individual ones. Here's my methodology I output a...

Hi All I have an Access 2003 front end, SQL Server 2000 backend. I import data from a spreadsheet to a table called Form_Import using TransferSpreadsheet, the table doesn't exist at import so Access creates it, makes some mods to that table and process the data in it using DoCmd.RunSQL and...