CODEWITHSUNDEEP
databasems-access
John Smith
John Smith

Reputation: 12256

Cutting down a very large table into something importable

I have a .dbf file that is over 4 GB in size, which is too large for the MS Access 2003 2 GB limit. However, the relevant cut of data I need is < 2GB, which is usable in Access.

Lexicographically speaking, I want to make/import all rows for which the string field FIELD is ">D2*" which means anything from "D3..." onward.

Can this be done? (I also have Access 2007 to use)

Upvotes: 0

Views: 650

Answers (4)

Nick Zinger
Nick Zinger

Reputation: 1174

I just had this problem, and what I did was:

Upvotes: 0

Mike Sherrill &#39;Cat Recall&#39;
Mike Sherrill &#39;Cat Recall&#39;

Reputation: 95632

Lexicographically speaking, I want to make/import all rows for which the string field FIELD is ">D2*" which means anything from "D3..." onward.

Yes, you can do that. Ideally, you'd just attach that table (File | Get external data | Link tables, I think, in older versions of Access), and select from it. If you can't do that, you'll need to export the result of

select *
from your_table
where your_column > 'D2';

Then import that into Access.

You might be able to export into a format that Access will attach. If you can do that, your life gets simpler.

Upvotes: 0

Sablefoste
Sablefoste

Reputation: 4192

If your file doesn't have more than 65,536 records, you may want to open the file in Excel, and export to the appropriate .mdb or .accdb file.

Or, are you asking for a specific query to identify the rows in your existing DB program?

Upvotes: 1

Morfie
Morfie

Reputation: 670

Is this a one-time import into Access, or do you need to do this multiple times? If it is a one time thing, I'd use a DBF filtering tool, then export it:

DBF Tools

DBF Viewer 2000

Upvotes: 0

Related Questions