Possible to import 5G csv into access?

[jwang036]

I have a csv file sized 5G. Is possible in any way to import that file into
access 2003? I can split it,say import N times as long as it can be imported
part by part.

Or is it possible to just read the file via access? I'm open for any option
as long as it can accessed.

Thanks!

 

[Jerry Whittle]

I'm 99% sure that the answer is no. An Access .mdb or .accdb file can only be
2 GB in size. I'm thinking that the 5GB csv won't get any smaller when
imported. I might be possible to put parts of the file into multiple Access
files then link them together; however, I think that performance may be an
issue.

 

[Mary Chipman [MSFT]]

If you can split the file, you can import it into multiple mdb's. then
create a front-end mdb and link the tables from the multiple mdb's.
You can use UNION queries to perform the joins, but make sure you have
partitioned the data in such a way so that you're not pulling
everything into the front-end just to get a subset. Really though you
should use SQL Server if you have large data -- Access isn't really
designed for this.

--Mary

 

[Sylvain Lafontaine]

Sure if this file is mostly emptiness; ie., blank spaces.

The limit for an Access file is 2 GB but this doesn't mean that you can
store 2GB of data into it because you must take into account the overhead
for each record, the lost of space for storing these records into data pages
and the size occupied by various things such as the indexes.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server
(French)