Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Maximum of fields

Status
Not open for further replies.
ping99

ping99

Technical User
Mar 16, 2006
45
CA
Hi all,

What is the maximum of fields in Access 2000 o 2003 in one single table we can create ?

because I have a text file with 1200 fields to be imported
into Access table.

TIA
 
Sort by date Sort by votes
255 minus number of index

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 
Upvote 0 Downvote
Sounds like you have a severly un-normalized table. Are all (or most of) those columns repeating fields?
 
Upvote 0 Downvote
The typical way to do this is to break the 1200 fields down into a number of ('Related'?) subsets and treat these as independent (but related through PK and FK) tables.




MichaelRed


 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

M
  • Locked
  • Question
display a calendar with appointments in body of html email with access vba
Replies
1
Views
3K
SoftwareRT
SoftwareRT
Moss100
  • Locked
  • Question
Remove everything including the comma from the last comma of a string. 1
Replies
10
Views
725
Andrzejek
Andrzejek
Moss100
  • Locked
  • Question
Stop user changing size of Access Application (not form)
Replies
1
Views
553
Andrzejek
Andrzejek
AS Mughal
  • Locked
  • Question
Select Multiple Images and store their file path and image name in text fields of ms access table 1
Replies
7
Views
375
Andrzejek
Andrzejek
Aamir Saeed
  • Locked
  • Question
Many labels on form.. want to change backcolor of labels thru loop 1
Replies
6
Views
260
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top