Storage

Ask something
Question Locked

SQL Export to Access HELP!!!

0 helpful
3 replies

by andy

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I need to export a table that is 258 wide and
appending for length. I get an error of "not enough storage available to complete this operation" [ODBC Microsoft Access Driver] Too many fields defined.

I guess Access limits the number of columns.

Any recommendations ?

3 replies

by tony hopkinson

To be quite honest Access is not going to be happy with that many columns anyway.

You are going to have to break it up, something I'd recommend anyway, how much storage per record?

Just split the table vertically, Key and the first 100 + fields, they the key again and the rest.

Then it's a one to one join on the other side.

Personally once I get to thirty fields in table I figure I've made a mistake somewhere.

by wildflower57

You might want to break that table up into two or more tables. Unless this is a fact table for a star schema, you really should consider trying to normalize the database a bit to reduce the number of columns.

This discussion is closed to new replies.