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

BerichtErwin,

  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.

Jim Dettman
President,
Online Computer Services of WNY, Inc.
(315) 699-3443
jimdettman at earthlink.net

  -----Original Message-----
  From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Erwin Craps
  Sent: Thursday, July 03, 2003 3:24 AM
  To: 'accessd at databaseadvisors.com'
  Subject: [AccessD] Importing DBF file with more than 1024 fields.


  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



        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  ·  www.boxoffice.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

  Box Office  ·  Fax: +32 16 296 406  ·  Box Office E-mail:
Staff at boxoffice.be

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030703/cd8239eb/attachment-0001.html>