Avoiding column limit in Access

[Josh]

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.

 

[prabha]

Hi Josh,

How about importing the document into Excel and make whatever modifications
then import into Access?

Regards,

Eric Butts
Microsoft Access Support

"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."


--------------------
| Content-Class: urn:content-classes:message
| From: "Josh" <[email protected]>
| Sender: "Josh" <[email protected]>
| Subject: Avoiding column limit in Access
| Date: Wed, 18 Feb 2004 10:50:23 -0800
| Lines: 12
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MIMEOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcP2UBDbRUj9MD94SdKBDGfw6m/3Cw==
| Newsgroups: microsoft.public.access.setupconfig
| Path: cpmsftngxa07.phx.gbl
| Xref: cpmsftngxa07.phx.gbl microsoft.public.access.setupconfig:29116
| NNTP-Posting-Host: tk2msftngxa14.phx.gbl 10.40.1.166
| X-Tomcat-NG: microsoft.public.access.setupconfig
|
| 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.
|