New problem. I have a table that is generated from and extract off of an FTP server. This base table [import] needs to be updated every day from that ftp server. From that import table, I run date calculations on about 20 fields to build a report on turnaround times for orders.
What I am looking to do is use the original table as the starting point and append or update this table from a temp table brought in through a macro every day. I have tried the append query as well as the update query with very little luck. I can get the update to work, but even if I set the properties page to update only unique records, i seem to be doubling the size of the tabe each time i run the query. Any thoughts on this?