![]() If I am really at capacity, can anyone recommend how to merge two txt files, as I am past the notepad limit for such.Īgain, thank you in advance if you can help, I am in a bad spot trying to jump this hurdle. I have done the compact and repair database multiple times. I already have compact on close, and clear cache on close, enabled. This just seems like it should not be a problem considering the data being used is only linked.Ĭan anyone tell my if my scenario should actually be causing a data cap limit, or if there could be something else wrong. I have a series of databases I have had to split as the dataset has grown. I was able to merge them fine in Excel's Power Query, but there is no way to export that query as a txt file like in Access, which is what I want to do so I can get the data into my next database. I am pursuing other routes to try to merge these two txt files, but I am having no luck with that. I know there is a database size cap of 2 GB, but the database itself isn't even close to that, and the files in it are only linked, so it seems to me that another query to run a UNION of the two (not loading them to a physical table) should still run. The databse size is showing 512 KB, the two txt files that are linked (not physically loaded) are 1,245,342 KB (or 3,504,398 records) and 797 KB (or 1717 records). ![]() ![]() I saved a copy, deleted any other information other than the two linked files I wanted to UNION, and tried to run the query and it still choked. Were the MS Access tables migrated to the possible new version required by the new software. I have a database that choked when I tried to run a UNION query. I have a Union query pulling together from two tables. I am using Microsoft Office Pro 2019, so Access and Excel Power Query 2019, on a PC, 64 bit, 16 gigs ram, windows 10. Greetings, and thank you in advance if you can assist.
1 Comment
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |