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

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