Limit on Data?

[Sash]

Is there a limit to the amount of data you can import? I'm attempting to
import a large amount of data and it keeps hanging up. Would I be better off
importing into SQL Server and linking to the data?

 

[Jeff Boyce]

Not much to go on...

Yes, Access has a limit on the number of fields in a table ... how many are
you trying to import?

Yes, an Access file can hold 1-2 Gbytes (depends on version, settings) ...
how many are you trying to import?

Yes, Access data types have some limitations -- for instance, you can't
import more than 255 characters into a (single) text field ... how many are
you trying to import?

More info, please!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Sash]

I'm getting messages like invalid argument...or invalid search key.

I have 4 files, 24 columns each, none more than 255 in length. However, the
first file finally loaded with 3,380,024 records. I'm not 100% sure how many
records the other files have, but I'm sure it's about that much. Am I using
the wrong tool? Any suggestions on my approach. The unfortunate thing for
me is that I've written queries for smaller clients to analyze similar data.
I was trying not to re-invent everythign.

 

[Jeff Boyce]

In addition, Access has a limit of approximately 2K for any one record.

If your records are 24 columns wide, each column up to 255 characters, you
may be hitting that limit on some records.

As for an approach, perhaps you can determine a well-normalized structure
and only import a small number of columns into the appropriate table(s).

Regards

Jeff Boyce
Microsoft Office/Access MVP