<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Bericht</TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1170" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=780530216-03072003><FONT face=Arial color=#0000ff
size=2>Erwin,</FONT></SPAN></DIV>
<DIV><SPAN class=780530216-03072003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=780530216-03072003><FONT face=Arial color=#0000ff size=2>
Why not just open the file direct and read the records in using Open and Get or
Line Input? Then parse and split as need be.</FONT></SPAN></DIV>
<DIV> </DIV>
<P><FONT size=2>Jim Dettman<BR>President,<BR>Online Computer Services of WNY,
Inc.<BR>(315) 699-3443<BR>jimdettman@earthlink.net </FONT></P>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com]<B>On Behalf Of </B>Erwin
Craps<BR><B>Sent:</B> Thursday, July 03, 2003 3:24 AM<BR><B>To:</B>
'accessd@databaseadvisors.com'<BR><B>Subject:</B> [AccessD] Importing DBF file
with more than 1024 fields.<BR><BR></FONT></DIV>
<DIV><SPAN class=060562007-03072003><FONT face=Arial
size=2>Hi</FONT></SPAN></DIV>
<DIV><SPAN class=060562007-03072003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=060562007-03072003><FONT face=Arial size=2>I need to import
or link a DBF file.</FONT></SPAN></DIV>
<DIV><SPAN class=060562007-03072003><FONT face=Arial size=2>Nothing special
about that next to the fact I have a DBF file with more than 1024
fields...</FONT></SPAN></DIV>
<DIV><SPAN class=060562007-03072003><FONT face=Arial size=2>I can link but
access returns error opening it or even with building a limited SQL
query.</FONT></SPAN></DIV>
<DIV><SPAN class=060562007-03072003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=060562007-03072003><FONT face=Arial size=2>I tried to import
in SQL server 2000, but same issue, to many fields.</FONT></SPAN></DIV>
<DIV><SPAN class=060562007-03072003><FONT face=Arial size=2>However, I can
open the file in Excel.</FONT></SPAN></DIV>
<DIV><SPAN class=060562007-03072003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=060562007-03072003><FONT face=Arial size=2>Anyone an idea
what to do?</FONT></SPAN></DIV>
<DIV><SPAN class=060562007-03072003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=060562007-03072003><FONT face=Arial
size=2>Thx</FONT></SPAN></DIV>
<DIV> </DIV>
<P style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px" align=left><FONT face=Arial
size=2></FONT> </P>
<P style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px"><FONT face=Verdana>Erwin
Craps</FONT></P>
<P style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px"><FONT face=Verdana>Zaakvoerder
</FONT></P>
<P style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px"><FONT face=Verdana size=1><A
href="http://www.ithelps.be/jonathan">www.ithelps.be/jonathan</A></FONT></P>
<P style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px"> </P>
<TABLE id=AutoNumber1 style="BORDER-COLLAPSE: collapse" borderColor=#111111
width="100%" border=1>
<TBODY>
<TR>
<TD width="100%"><FONT face=Verdana size=1>
<P align=center>This E-mail is confidential, may be legally privileged,
and is for the intended recipient only. Access, disclosure, copying,
distribution, or reliance on any of it by anyone else is prohibited and
may be a criminal offence. Please delete if obtained in error and E-mail
confirmation to the sender.</FONT></P></TD></TR></TBODY></TABLE>
<DIV align=center>
<P style="MARGIN-TOP: 5px; MARGIN-BOTTOM: 3px"><B><FONT face=Verdana
color=#000080>IT Helps - I.T. Help Center </FONT></B><FONT face=Symbol
color=#000080 size=2> · <FONT face="Courier New"></FONT>
</FONT><B><FONT face=Verdana color=#000080> B</FONT></B><FONT
face=Verdana color=#000080><B>ox Office Belgium &
Luxembourg</B></FONT></P>
<P style="MARGIN-TOP: 1px; MARGIN-BOTTOM: 1px"><FONT face=Verdana
color=#808080 size=2><A href="http://www.ithelps.be/"
eudora="autourl">www.ithelps.be</A> </FONT><FONT face=Symbol
color=#808080 size=2>·<FONT face="Courier New"></FONT> </FONT><FONT
size=2><FONT face=Verdana color=#808080> <A
href="http://www.boxoffice.be/">www.boxoffice.be</A> </FONT><FONT
face=Symbol color=#808080>·<FONT face="Courier New"></FONT>
</FONT></FONT><FONT face=Verdana color=#808080><FONT size=2> </FONT><A
href="http://www.stadleuven.be/"><FONT
size=2>www.stadleuven.be</FONT></A></FONT></P>
<P style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px"><FONT face=Verdana
color=#808080 size=1>IT Helps bvba</FONT><FONT face=Symbol color=#808080
size=1> <FONT face="Courier New"></FONT> · <FONT
face="Courier New"></FONT> </FONT><FONT size=1><FONT face=Verdana
color=#808080>Mercatorpad 3 </FONT><FONT face=Symbol
color=#808080> ·</FONT></FONT><FONT face=Verdana color=#808080
size=1> 3000 Leuven</FONT></P>
<P style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px"><FONT face=Verdana
color=#808080 size=1>IT Helps </FONT><FONT face=Symbol color=#808080
size=1>·</FONT><FONT face=Verdana color=#808080 size=1> Phone: +32 16
296 404 </FONT><FONT face=Symbol color=#808080 size=1>·<FONT
face="Courier New"></FONT> </FONT><FONT face=Verdana color=#808080
size=1> Fax: +32 16 296 405 E-mail: <A
href="mailto:Info@ithelps.be">Info@ithelps.be</A> </FONT></P>
<P style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px"><FONT face=Verdana
color=#808080 size=1>Box Office </FONT><FONT face=Symbol color=#808080
size=1> ·<FONT face="Courier New"></FONT> </FONT><FONT face=Verdana
color=#808080 size=1> Fax: +32 16 296 406 </FONT><FONT face=Symbol
color=#808080 size=1> ·<FONT face="Courier New"></FONT> </FONT><FONT
face=Verdana color=#808080><FONT size=1> Box Office E-mail: </FONT><A
href="mailto:figures@boxoffice.be"><FONT
size=1>Staff@boxoffice.be</FONT></A></FONT></P></DIV>
<DIV> </DIV></BLOCKQUOTE></BODY></HTML>