Hello. I have a column of account balances in an Access table. I'd like to periodically update them with the corresponding values in a Quicken file. I can export from Quicken to a text delimited file and import that data into an Excel worksheet. I can import from either the worksheet or directly from the text file into Access, but I don't see how to replace the access column with the imported data in automated fashion. The data from Quicken is not in the desired sequence. I can reorder the rows in the Excel table and copy and paste into the Access table, but I was wondering if anyone knows a more automated (or more elegant) way. I'm aware that I can link an access table to an excel table, but I'm not clear that it can be done with the desired resorting of rows.
Thanks for any suggestion,
RonL