MS Access data conversion - Access 2003 can't manage dbf with more that 256 fields

Author

Access 2003 can't manage dbf with more that 256 fields

Massimo Belgrano

2005-09-22, 9:24 am

I have a access97 application wiho have as attacced isam table a Fox 2.6 dbf
with more that 256 fields.
I have problem in migrating to Access 2003.

How can i attach this table in Access 2003?

Odbc from access is limited to 256 fields?

begin 666 dbf with fpt with more 256 field.zip
M4$L#!!0``@`(``$#;BK
<G>6UB@L``&UL```&````4% N1$)&[9O+DMNX%8;1
M]GBFDYI)-EFDLDAID:HL4E8`\"(QR@;B1<,*;R8A9:8WK%GD!5*S&*<JV>1%
M4GF4O%/V.>!-%(F+VE9W; _1;HGJ#SBX$#@\/R#_]^[ESUXAA/[]V_]\A23I
MR,.,AXA:_-X/WO[A[4N4NPC]\)=[=(_^]L_@+<NR'(WXBPG/CFE=E.$)\?M,
M\"\F/."LYX'@]Q/NYT%>!DCPQO[G$QXEM9^G*>KYW81#X3*.$%*5!_M^$JOY
M*<R"F)_YK/^'\,+^E&<YC-Z(_W%>/]OO&]Z,ST^F]O?[E'$-+WU6BQ9T]E]-
M>%'FAUID0AHNQA^I[M\I/)1(R7E<Y.(&]GPZ_H?R6 #/`T7]27Z(:VA=H"Q?
M0&DT\,_F[??#O%"6CX,L_#/+6-^^+V4\S@(5]QFO80X@5?^Z_@_]FXZ/G["J
M"I&2AWN8OXF6I\SWE?U/\Z".2J3L?W8*2S%]@$OG3Y:7\8..%Y4PK^0%*Z%]
MZOJ;_@6UF,/2]OMY!,7/7%+^6]3RUG^\F-R_*OR&^1QIRB=[U/!,MCZ!LX3O
M<UB"F:Q]3?OK4*S@AM_?S7@5<33P:?L$[SR BA<PN[0\T?.P&'%)_\*#GE=%
MPC@[R#F#\6/@? 8%+_1=PF()G_DL)AQNL*
U^P2EN^8$6!-.6S.-7R@!7EP'^8
M<UCBX<!_(^-^KN?<U_,W1R6'\3_YJ.&J^7?B>@[6M9SK[$=1#=/OS%_,>3*N
M?SK_$EY7,#Q#_^YDY1.D+ ^\8)&>P_Q6\B)MUH^.@W\E0_MFS[]4[Y^ IW&%
ME/X)^(D3E*K\B^"^GG,#?W,TV.?44#\UU$\-]>MY4I#S^+R2<6K@EH';!NX8
MN*OE&1N-[PL9IP9N&;AMX(Z!NVJ>U> #]ZB)%ZOM3QA5$`(KY*R
!+"Z;B15DW
M[K6W?S_GC',MCXYM_2H.]L-*;U_+A7W((.?P<.(E0X)+XRO@!?B&@4_7/\\3
M$7\._-4L?DGKKGQ3_ZN[*0<\XG-]4_O!2<,A_A0"2-5^H9](DC<AGJR\X-3
M+0U_T^@S@OKXX4LIIP9
N:3GTCQ@X-7!+Q9.XJB'/8/_G+Z6<&KBEX\<L1CK.
M3B>D:]^)E4H.TNJA;H9?;K_AU, M#7_HFZ>H_Z%OGI)WW9?;]\&Y"'6(NOD[
M]4\GEK #5]M/0;OFF98?N@Q2#IVK]R"PAOAYJO_ >^IX43XTZT]E/\[\Y%C%
MNOO+XRQ7\HAQD%!\&)^[^?Y Q(0'[OCG<_\5MECEWZ-\S'\Q'1\NS"-E^0R"
MXX3EI=J^_W4<!DK[4']8MA5(N? _9;L#(_4_$?L&=5Q:7@1O</\KU?@$C+?[
M(PK[,'YB^D1(X5_]/.1^<N:R]G?U*_TKW/^$ETH>UT=>(#6/#+P^EO#XT' _
M3$(=!WU5ZGC^)SUOYI>:"^MZGNIXG(&+*+2\TO/*_UK9_RBI(Q\U7#J_JU T
M$ U\II_\NLNBY-!%)+BT_BJNFP!,N;["+*B+,$D4\V^?[Q/0SP._F_G7,CY
M`*3B(3_RN-D?D\<W91Q <'7V3U_,G[_0_[/_^/M\?^[$#N' _S&M/ZK[+%(.
M]Z<,3T?0H/+VQQFOFSW6CO]+XC^/H_;/]H\?A/ YKMECE^E5PL46EYN$!Z7
F[
M1:3DS?Z0BE?[)(?9,?"7,W[D8_YB/GYB_R-3M@_F__X8'%2\\@<NU1=0ON+M
M$UYE'^X?1,E:SD-?RYG_1LTAOJ\B3?VLLC'6\&;W5L/C=(]TO-57:BX>#[EJ
M_?GLV&>0KF]87$5Y0 .?[W^#?T$-E_J7.- 5S4;\(_U7U'WE8BOV=GK
^4<+'Z
M=%RL#A4/.:BKEDOCKWYSMN=W,_\.S[X1?RGQ_SH.8Q]U7+I^H/)XS&?Z.@[S
M0Z:V7X2EEH<\:< )K%4_V$)]IR\>E4&\]?S7C8GM5WW^Q0:SB/"X@/DB&_L_&
MG]3-XNPYG7)JX):!VWH>Y6630;4^TH3V7'I^D>PO^6<S_U>(S4&".O[E"RFG
M.@X:1,MA#B&M?>B_EHL-5FW[P(/T_9_SKH.J\KY?-^Y;Q1F8'^T/S#C/(43@
M6IZH^<-#&OA(SU.DLP\14%X2`Z<&;AFXK>;-_2<Z?F*EB5,#MPQ<VSYQP*/F
M<'O;&:KD\(2*4Z:</W615PSI>%A&:E[4$ "5*A[5WZ(QGYT?B.,!+6\\O.!2
M_UZ"_8Y+RY?"OI;K[1=!?@K)F<^>[SX,WHC_6E:>&LI30WG+4-XRE+<-Y6UU
M^9"WYS,]_ZF44P.W#-PV<,? 70/?&/C6P#T#)UC%BQ3T:W/ I>74P"T#MPW<
MT?"3H7TG0_M.AO:=#.T[Z=H7M=-/SZF!6P9N&[ACX*Z!;PQ\:^">@</T4_&R
M6[Y:3@W<,G#;P!T#=PU\8^!;`_<,7#-^XOMSG#T(GLKX5VBU#Q//64&BVRWQ
M/)L0NL48TZVW:E,*'RR"+9')Q@ZA>/5>"<\NVI2%/*>FPJ%H!>4,.QI[F!&K
MR4"=-<:913& !'L'GK4O6XMU:MQ_7CK,
"*#Y1[(E/*[(B!"Q4/(]V9165N^@(
M+^)[3CL?U,SNB@[2'8,?'WXO_RY:O9N^^ Z^QB;9M3]TGKDI+WNYYE
Y,B^T>
M>2]WC[BX18()LFM-CG]ES7JN/,VTH]T[;E_%K.O> 56_CXM)_AC5T_H%_U60%

M&-^Q'>+-ZG>_?TUPTR)%OBL7LN+:<S#&QORVO?8\=T36%Z7T'U5M> HC5W09
M7Y/+IAO;? 5\GNJ0E+4GJE;(88@EPO
]5-K5[ZY4M'?9W/_DB'\R*P&CV[WOGZ
M)D8^G>M96*"($Y:T)'D:%)P-6D8H.$HM+%*OIK[';2(W] FCBXTM]"&D-"2^
ML8[0@78X('[LS*#@*-BRO?5VFQ%WTRFXC87'"HXV;P[NW[;P9C7_I@HN\%G2
MOEPAXYQ&P0F]=:GA1*MWDQ>?8>\:&7=6<-;.J. HN5;&337?Y.6V"NX64DZN
MX"XM/V>>3KV=?_\O"@XJ\YHU>K9I$6=C$Z6"(ROFDR=5< 2/6N2,6W>9GUAK
M:GGGCYLUMJSW%%^$W%S
!N=3#+MW,K@GUML1RYPJ
.C > T.%V$ NZBTU/YRH^
MK,N\JN+1WR+V#9EN<?4> V]NXV!T+84@,_+E#^APG
K6^%7.!9U3Z^Y<T30KQO
MI)QBUSAI(-M%)FF<74V<S&-^EB?ZCR<=% JNRJI*H^!@LFZQ,Y_$JF
=.MX[Q
M:@-SGS"5@F.+@EL4W$T5'/EPII1X&.6M8(A9YN>+\_E@4A &GMW%6=W3OHD&
M21]&[>':L[$M,A7?_?7[-7,LE^Y7#"X=;(7OJ>!<XKB6"!TR4'!7G,%!5G$&
M1& #91;4*#MHOFFLWL339#F
=PCD3!N4[[MEEOK"8.M^<*[MKCM];C-PJ.S?*+5N]&
M+U<>OXT4'-V95=BC8ICW*?L,>DU5I?9,& #91;)GS#,^XC^H,SBK;,
SAG]61G<+:[
MN5)M.?36QV?>S14<!>>X(=[L>D6%)),H.+$C9LGJ<:R-M[6?87]UCXEM#]]5
MD"NX1GF!"S8IN)LE(?3&GS-9IFQY+"_IBE0<"?&L\28'+#*_JJJ,5[>=1.)+
M27AEB]T+I8+;+PI.=0V*V5UOG$6U?;1G<%E8=JJ-E:#@XD7"?8@*SKU0<+92
MP5FVC1G<2;Y>V1N;/M)73A4<MC<NMEH%=]T9'+E&P0G';C7?HB2NTY_!;:CZ
M#,Y:BW#'>G\%1Q8%MRBX1<&UQW"F/%M[NR:V?6,%Y][^6Y2O7>SV9X6CZ]>.
M99$ME2BXQK?)ZH$N7_3XQZ;@G$<JN.7,;4DJ!8> )LZV>1\$YBX)[=\%B8[PF
MRQG<IZ#@EO2!)?$MRC88\3R*Q5,<DR+,3^PI?<(CXL1WL(=7TU4R_+&-5C6A
M]:?\G?8E/>4S[E+!K9Y3P:T>J^ NC3V5@KON^E&2[1/X?W W=7Y+6M*25D^^
ML);_!W< S\;*HMH]1P2WI0TV_^A]
02P,$% `"``@`<JTZ*K=?-XW6! ```)@`
M``8```!P<"Y#1%CMG4V+Y$08QY^\.*^MTRXB(\K0S,JRZPQ-Y:U?1'<F+]7K
M0#IINS/#KJ"]!Q$1#SLBXD&D63R(!_'@S8L?P8,?8/3H0<2#H(+NT6\1D^I.
M)SV'O8E,ZO^'Z4I5I9G
A/\DOE2=/54BGI;;H$4&R2%G\0#)+HUU*%WJHI"G1
MSDY3US5:&]$KG#Q.KW&*."6<WN!TG],[G-[G] &G1D(?<_J4TV><KB6TF]!>
M0B\F]%)"+*%.0E_8]%4'#O_?LKEI]7O=CF-;IL',<G,TYF=&!OVE&G0?=DFB
M/<'^/3I-> )3PUH$;1? %!:Y*,;T:GPVE^:!QV;\
$F"?BO+_E_4>%_=G2HM*E1
MUKT-EZZV.@$/^G9+R+%-YO&P[^05L]>C9KG?/O@OC<:"_V,:A--)DN'^($<_
M]Z;W#KN'YJVB%GHKU5&T6@WGU6QSZ/K^@1\/7!_67EG^OZFD.T1'1XVU-4TG
M76.Z0KK*8-)_. CSOMWN]EM'IMAG+\,R*H
L<2E]E& E%':R=LL4W29S)@7_;;C

M9'LXMF@V> O,O=IQYT6UWK:S7]%LM2
S09BY[B%UAM._^Z2<^6?\H&O8O_AR1:
MITWQZ<>!ZWF+XC;.=?GX3TO^_U.-_T!RZ(5R<PW\EXC_3Q?\C\?!HKC]ZCX3
MVH=!$H[_?\GXK]'Z^C5-T]2\JZG3,PHUX%*]9/;ZMF&)$]VDRJFN(_XC$?\5
M\3GAB3L:P0_P/TU_J_!?H9D(_C=4\+^>ZCA])^/_S;)E`_R71MN"_]L4).[T
M)(K#9 Q/P/_J\]'*C&-')T<N%1'_>!]]\UL1NVR90W\EV[\[\>!'Y[ #_ _
M37^JC/_%X']79 %!M=&'(N@S9,RT#(\QHV^37?8^"?Y+HQN"_S<>G_]Y, BG
M?CP<PBXI^+^:_]E4Z3GQ".!YN'2U]=C\SY?+_1#_ET=%_(=[&>&#Z=!-X(GL
M_/^U,O[7\ZZ&FD\11/ R_=G(,BYEV=BM@T7'9BO
B_/-H1_-]9//\M4OCAB\S\
M_W%U_I<(`6DJ(1?TZM\!Y',)1+Y__LPW+_/A?SY]@ ;E7D^ _])H2_!_BT;C
M^,[4'?LN+)&>_S^OY/]\*VX!=,3_:Z:N;5J&X72L#K.['0JKQP+X+XN*Y[_S
M^#_\`/_3] \Q_U?3&JJJ*J2RK \3`FNK@ <>#ZF2]Z> _])H4_!_<[G^`QP!
M__]2TJ.,`LI3BJ)F[<?9-> 8#M59D4]WP7\95<1_,OZ/^9D?(\<'_*_R/V=_
M?@V 0W76Y(3>`O_!_X3CT2_X_W>5_S-U!O[7_P) ;X/_X+_KOPY+P/]5_I-V
M#/[7GO_O@?\RJA+_'WBGP1TX`OYC_"^=!O0`_)=1&X+_&X09ON!_P?]'E_D_
MTV=PJ.;ZJ'HL@/^R:+G^IQ?&0ZS_"?[/^5_F?UZH%]J%?@&':JY/P'^9^7_&
MH^ $:S^ _YE^K_!?):6I- 9'_7UO9MN4P9M##:DP`_
)=%1?P_2$XB-W1Q!P#^
MIW]>7O_Y7*-SG<[A4FTUH\_+"N+_\J@2_Q^-XP"&@/_(_Y%/$_JRK#3 ?VET
M7?#_>OG^]W(AT$LO?X=7LO#_^\KX?[GXCY+M`%TY.8L7QD?Y2I^+U\O;B]?$
M^_G"GXLWPM/7U3$A^" ^+BOB_ZWE8^QG\1_Q'3L
U@@=SZ%U!+`P04``(`" `!
M`VXJSIY=8A8``````@`
`!@```%!0+D905&-@8!!@8&!0"/:L\$W-S6<8!2,+
M``!02P$"% `4``(`" `!`VXJW)WEM8H+``!M; ``!@`````````!`" `MH$`
M````4% N1$)&4$L!`A0`% `"``@`<JTZ*K=?-XW6! ```)@```8`````````
M```@`+:!K@L``'!P+D- $6%!+`0(4`!0``@`(``$
#;BK.GEUB%@`````"```&
M````````````( "V@:@0``!04"Y&4%102P4&``````,``P"<````XA `````
`
end

Albert D.Kallal

2005-09-22, 8:25 pm

FoxPro 2.0 tables only supported 255 fields. It is possible that Fox 2.6
allowed more then 255 fields, but I was not aware of this fact.

Further, ms-access only supports 255 fields, so I have no idea how you could
actually linked to that table. (if you did, that is amazing, and very lucky
on your part).

Ignoring the above two issues, you can most certainly link to a FoxPro
table, and to do so you need the FoxPro odbc driver.

http://msdn.microsoft.com/vfoxpro/d...bc/default.aspx

I don't know about the max number of fields in FoxPro, but ms-access is
limited to 255...

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@
msn.com
http://www.members.shaw.ca/AlbertKallal

Albert D.Kallal

2005-09-22, 8:25 pm

Another thing you could do is open it with excel...that tends to open just
about any type of dbf file....

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@
msn.com
http://www.members.shaw.ca/AlbertKallal

Douglas J. Steele

2005-09-23, 7:24 am

Yeah, but Excel has a 256 column limit as well.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Albert D.Kallal" < PleaseNOOOsPAMmkalla
l@msn.com> wrote in message
news:uWKJNX6vFHA.2808@TK2MSFTNGP10.phx.gbl...
> Another thing you could do is open it with excel...that tends to open just
> about any type of dbf file....
>
>
>
> --
> Albert D. Kallal (Access MVP)
> Edmonton, Alberta Canada
> pleaseNOOSpamKallal@
msn.com
> http://www.members.shaw.ca/AlbertKallal
>

Bret Reid Jones

2005-11-08, 4:15 pm

bret
"Massimo Belgrano" < mbelgranoRIMUOVI@del
tain.com> wrote in message
news:OOqfzs3vFHA.464@TK2MSFTNGP15.phx.gbl...
> I have a access97 application wiho have as attacced isam table a Fox 2.6
dbf
> with more that 256 fields.
> I have problem in migrating to Access 2003.
>
> How can i attach this table in Access 2003?
>
> Odbc from access is limited to 256 fields?
>
>
>

Sponsored Links