[AccessD] Importing DBF file with more than 1024 fields.

Gary Kjos garykjos at hotmail.com
Thu Jul 3 07:42:01 CDT 2003


If you can get at it in Excel can you cut and paste it into multiple 255 
field (or less) worksheets? And them import those. Access has a limit of 255 
on fields I beleive.  You would need to have some common key value in each 
worksheet in order to join it all back together.

Gary Kjos
garykjos at hotmail.com





>From: Erwin Craps <Erwin.Craps at ithelps.be>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: "'accessd at databaseadvisors.com'" <accessd at databaseadvisors.com>
>Subject: [AccessD] Importing DBF file with more than 1024 fields.
>Date: Thu, 3 Jul 2003 09:23:54 +0200
>
>Hi
>
>I need to import or link a DBF file.
>Nothing special about that next to the fact I have a DBF file with more 
>than
>1024 fields...
>I can link but access returns error opening it or even with building a
>limited SQL query.
>
>I tried to import in SQL server 2000, but same issue, to many fields.
>However, I can open the file in Excel.
>
>Anyone an idea what to do?
>
>Thx
>
>
>
>
>Erwin Craps
>
>Zaakvoerder
>
>www.ithelps.be/jonathan <http://www.ithelps.be/jonathan>
>
>
>
>
>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.
>
>IT Helps - I.T. Help Center  ***  Box Office Belgium & Luxembourg
>
>www.ithelps.be <http://www.ithelps.be/>   *  www.boxoffice.be
><http://www.boxoffice.be/>   *   <http://www.stadleuven.be/>
>www.stadleuven.be
>
>IT Helps bvba* ** Mercatorpad 3 **  3000 Leuven
>
>IT Helps  *  Phone: +32 16 296 404  *  Fax: +32 16 296 405 E-mail:
>Info at ithelps.be <mailto:Info at ithelps.be>
>
>Box Office **  Fax: +32 16 296 406 **  Box Office E-mail:
><mailto:figures at boxoffice.be> Staff at boxoffice.be
>
>
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com

_________________________________________________________________
Help STOP SPAM with the new MSN 8 and get 2 months FREE*  
http://join.msn.com/?page=features/junkmail



More information about the AccessD mailing list