I have a 7 GB text file that I need to load into Access. Access has a file limit of 2 GB.?

Question

Is there any way that I can get around this? If not, is there any way in which I can split the file into 1.9GB files that are still useable i.e. Doesn't require a .bat file to put the file back together again [rendering the process useless for my purposes]. Thanks

Answer 1

Sounds like you are in quite a bind. I suppose you could write a vb script to split the file, but it would have to parse and loop through the file and split it at certain intervals. To be honest that would be far more difficult to code than just using a SQL database and SSIS to load it in. Querying the data would be easier then also.



You could try SQL Express (it's free), but then you don't get SSIS, you would have to load the data via BULK INSERT code.

Answer 2

7 GB - that may need some thinking. If the FILE you want to split up is containing data of some importance - which is assume it is - then, splitting up should be done carefully. About the LIMIT of Access, i am not sure. A 2 GB limit is - i know on UHarc. But don't think so with access. Consider your computer hardware data protocol may come into account. Hope this helps.

Answer 3

Regardless of what you do, Access' limit means that you can't have more than 2GB of data in a single database. Period. Not even if you use SQL.



I suggest that you use another database - one that has a limit of 10GB or more. 7GB of data isn't trivial - and Access is a trivial database program.



(Maybe you should rethink your data - I can't think of many datasets that would take 7GB - AND could be manipulated in any same way without SQL. And I work with databases every day that make your dataset look small.)

Answer 4

Technically, you can not do what you want. But more importantly, I would need to first ask why you want to use a database solution for a text file to begin with?



Each tool has one basic purpose, and if you try to use a hammer for every problem, so the saying goes, everything begins to look like nails.

Answer 5

this happens immediately. as quickly as WinRAR opens the report, the working gadget starts examining forward into cache. because of the fact this methodology keeps to ascertain the report, the working gadget keeps examining forward immediately. there is not any longer something particular you may desire to do. WinRAR is already smart adequate to tell the working gadget that it will examine the report sequentially and in bulk, and this triggers aggressive examine forward.

Answer 6

How did you get 7 GB of text!?