Access and a Large Text File: over 8GB
Posted on 2013-10-24
I was hoping to get suggestions on the best way to handle this situation. We have a large text file with many fields and many records. The size of the file is over 8GB. We need to be able to look at the data to ensure fields contain correct data, and to be able to massage some of the data. We will be using MS Access 2010 as the front end.
I know there is a 2GB limit for an Access file, so I was thinking that we could import all the data to a SQL Server table. We could then use Access to view and massage the data using vba code.
I want to install SQL Server on my desktop and create a database with that. Then I could link to the table that houses all the imported information.
My question is, can you install SQL Server and create a database all on your desktop and not on a server?