Prev: Access 2003 + a few other questions
Next: two level make table query and sorting???
From: joemeshuggah on 27 May 2010 18:01
what is the best way to go about doing this?

i just created a report that first runs a query for current month info in
teradata sql assistant and exports to a text file that is linked to an access
database. i then use an update query to delete the current month info from
the main table in access (prior months are left untouched), and then run an
append query to append the current month data from the text file to the main
table.

there is now a need for two additional columns. i modified my teradata
queries to incorporate the new columns and relinked the text file.

my question is, what is the best way to update the main table with the new
columns?

i initially thought i could modify the teradata query to pull only the new
column information historically, export to a text file, insert two new
columns into the main table (updating to show them as 0 instead of null),
import the text file information, and then use a make table query to
aggregate the information (to shrink the number of records). when i did
this, though, the data types for my long integer fields changed to double (i
cannot change them back) and the file size ballooned.

i know i can leave the appended records for the new columns as is and live
with more records due to the incorporation of the data for the two new
columns, but i would think that shrinking the number of records by
aggregating would reduce the file size...especially since the main table is
linked to a pivot table in excel.
 | 
Pages: 1
Prev: Access 2003 + a few other questions
Next: two level make table query and sorting???