Search results

Hi All I have a table in SQL Server, call it table1, residing in a database, db1. I have excel VBA code that was originally designed to run through a table in Access. The code performs a bunch of calculations, produces a few records based on the data in the table and the calculations, and puts...

Hi I have written VBA code in excel that takes an existing access table (1), does calculations and pastes the 'answers' in a different table (2). Through this process, for each record in the first table, about 20 are created in the second. Access cant handle all the records in table2, so...

Hi all I want to transfer all the records from an access table into a text/csv file. Im using the following code, but get error 424: object required: DoCmd.TransferText acExportDelim, "Exposure Export Specification", "TEMP_KN_DATA", "C:\Exposure Tool 2009\Exposure.csv" Any ideas? In...

I have a table (DATA) from which I am creating another table (TEMP). TEMP contains all of the fields of DATA, with the addition of several calculated fields as well as considerably more rows (1 row of DATA yields about 25 rows in TEMP). This has meant I cannot create the entire TEMP table at...

Hi guys. Does anyone know how to run a make table/group by query from vba? What I want to do it run a loop through, say, 100000 records. This creates a new table with some added calculated fields. After these 100 000 records, I want the code to make a table with grouping for a selection of...

Hi all. Hopefully someone will have the answer I am looking for :) I have an existing databade (db1) and table (t1). I want to perform calculations for each record and then create a new database and table (db2 and t2) to dump the data in. t2 will have all the same fields as the first table...