Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Database Design / February 2004

Tip: Looking for answers? Try searching our database.

Avoiding column limit in Access table

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Josh - 18 Feb 2004 19:16 GMT
I am attempting to import a tab separated text file into
access as a new table.  There are the equivalent of
374 "columns" (variables) in this text file, and of
course Access will only store 255 of them.  I don't care
about a large number of these variables, but my attempts
to tell Access NOT to import them, do not cause Access to
import remaining variables (beyond number 255) in there
place.  Instead, Access stops at what WOULD HAVE BEEN the
255th variable, even if this means it's only importing
14.  How does one get around this problem?  It would be,
in this case, very time consuming to try to modify the
text file, which is enormous.
Tim Ferguson - 18 Feb 2004 20:18 GMT
> How does one get around this problem?

One: normalise the data design. At least you can host the stuff in a
reliable fashion.

Two: if you really have to work with this flatfile, then the simplest way
is probably to write a short VBA parsing routine to send the data to the
right place.

Three: send whoever created the original file on a database design course.

Hope that helps

Tim F
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.