Erwin Craps
Erwin.Craps at ithelps.be
Thu Jul 3 13:56:57 CDT 2003
That was my last solution... I need to do this every day in the forthcoming two weeks... -----Oorspronkelijk bericht----- Van: Jim Dettman [mailto:jimdettman at earthlink.net] Verzonden: donderdag 3 juli 2003 18:05 Aan: Access Developers discussion and problem solving Onderwerp: RE: [AccessD] Importing DBF file with more than 1024 fields. Erwin, 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 <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 -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030703/d635199d/attachment-0001.html>