<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=US-ASCII">
<TITLE>Bericht</TITLE>
<META content="MSHTML 6.00.2800.1170" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=086031710-18062003><FONT face=Arial
size=2>Hi</FONT></SPAN></DIV>
<DIV><SPAN class=086031710-18062003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=086031710-18062003><FONT face=Arial size=2>I have linked DBF
files into my AXP, importing does not work, with more than 255
fields.</FONT></SPAN></DIV>
<DIV><SPAN class=086031710-18062003><FONT face=Arial size=2>I need to cross
check two identical tables, for typo errors.</FONT></SPAN></DIV>
<DIV><SPAN class=086031710-18062003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=086031710-18062003><FONT face=Arial size=2>But I can acces
these tables from VBA (tried DAO and ADODB recordset) with a SELECT * statement
due to these +255 fields problem.</FONT></SPAN></DIV>
<DIV><SPAN class=086031710-18062003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=086031710-18062003><FONT face=Arial size=2>I could use "SELECT
Field1, Field2, Field3" etc but you understand this is some typ
work.</FONT></SPAN></DIV>
<DIV><SPAN class=086031710-18062003><FONT face=Arial size=2>Is there an SQL
statement that I could use?</FONT></SPAN></DIV>
<DIV><SPAN class=086031710-18062003><FONT face=Arial size=2>Something that
allows me to select fields 1 to 250 and afterwards fields 1,2,3,4,5,
field 251 to last field.</FONT></SPAN></DIV>
<DIV><SPAN class=086031710-18062003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=086031710-18062003><FONT face=Arial size=2>Or do I really need
to typ in every fields name...</FONT></SPAN></DIV>
<DIV><SPAN class=086031710-18062003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=086031710-18062003><FONT face=Arial size=2>Or can numericly
refer to a field instead of using field names in my SQL
string?</FONT></SPAN></DIV>
<DIV><SPAN class=086031710-18062003><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=086031710-18062003><FONT face=Arial
size=2>Thanks</FONT></SPAN></DIV>
<DIV><SPAN class=086031710-18062003><FONT face=Arial
size=2></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></BODY></HTML>