<div>
Try importing it into Excel and generating a pivot table, saving that as a .csv then going to Access.<br />
wb<br />

</div>


<div>
The problem with excell is it will not fit onto one sheet
</div>


<div>
I am assuming you have 1 row in your table and each value should be a separate record rather than field. If this is the case you can either<br />
Import the file and then append each field to a new record or use VBA code to loop through the rew in the file.<br />
<br />
The standard Access imports uses the CRLF as the new record marker.<br />
<br />
Cheers, Andrew
</div>


<div>
you can read the text file using vba, parse it and append to the table <br />
<br />
dim s as string, sArr,j<br />
open &quot;c:\myText.txt&quot; for input as #1<br />
<br />
do until eof(1)<br />
line input #1,s<br />
<br />
sArr=split(s,&quot;,&quot;)<br />
<br />
for j=0 to ubound(sArr)<br />
<br />
currentdb.execute &quot;insert into TableX(Field1) values ('&quot; &amp;&nbsp;sarr(j) &amp;&quot;')&quot;<br />
next<br />
loop<br />
close #1<br />
<br />

</div>


<div>
I am in excell 2003 and I am over the limit, but what I will do is put it into a 2007 application
</div>


<div>
<div class="content wysiwyg-content">
I need to import a comma delimited text document into a table, the problem is I get 250 columns, and what I need is one column with 250 rows
</div>
</div>


I need to import a comma delimited text document into a table, the problem is I get 250 columns, and what I need is one column with 250 rows

import text document into a ssingle column

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.