Single character fields through memos

[whiskers197u8]

I am importing fields into a table from a csv file. The file has x columns and y records resulting in x*y fields. Each field in this csv file is being imported as a separate record in an access table. The problem I'm having is that I am currently at 1.9 million records, and that some of the data is as simple as a Y or N, while others can be as large as a full memo field. So I have set up my table such that the field that stores the value from the csv file is a memo.

This database has several relational tables. So why does each field in the csv stored as a separate record, and not into an table with x columns? Because the csv file (technically, it's two files) is approximately 350 columns, and Access can't handle more than 255 columns. Well, that last statement might not be true, however, I am importing the data with the objConn.Open method and setting a recordset to this connection truncates columns after 255.

I am not at privilage to share this db, so please don't ask. So my database is getting huge (currently over 150 MB).

Is there a way that I can save space in this table, such that when I'm importing a field that only contains a few characters, the database table won't reserve an entire memo's worth of space for that answer?

[June7]

I don't think because a field is set as memo type that the db actually reserves that full allotted space. According to http://office.microsoft.com/en-us/ac...102505209.aspx a memo field can hold 1gb of characters. Access file size is limited to 2gb.

It is correct that a table can have only 255 fields.

Does Compact & Repair reduce the file size?

[whiskers197u8]

That makes perfect sense. Also, I thought that that the size limit was 2GB for an access object, not neccessarily the size of the database. And compact and repair does help a tiny bit. Thank you.

[June7]

Access total file size is limited to 2gb. http://office.microsoft.com/en-us/ac...010341462.aspx