Christopher Hawkins
clh at christopherhawkins.com
Fri Sep 9 15:20:29 CDT 2005
Other .dbf files that are created by this program do indeed import into Access just fine. There are a few that do not (like the one I am trying to open). I am not sure what the difference is. UPDATE: I am able to open the file in Excel as a .dbf file. But I still cannot import the file into Access. On a lark, I tried connecting to it from an ASP page via a connect string, which didn't work either. This file seems awfully particular about who it will cooperate with! Opening in Excel but not importing into Access just makes NO sense to me. I've got every FoxPro and DBASE driver that Office offers installed. -C- ---------------------------------------- From: "John W. Colby" <jwcolby at colbyconsulting.com> Sent: Friday, September 09, 2005 1:52 PM To: "'Access Developers discussion and problem solving'" <accessd at databaseadvisors.com> Subject: SPAM-LOW: Re: [AccessD] SPAM-LOW: Re: DBF & Access: "external table is not inthe expectedformat" In which case it might not even be a dbf (dbase) file. You can call an mdb anything you want and Access will still open it. Maybe this thing just calls its data files dbfs. John W. Colby www.ColbyConsulting.com Contribute your unused CPU cycles to a good cause: http://folding.stanford.edu/ -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Christopher Hawkins Sent: Friday, September 09, 2005 3:36 PM To: accessd at databaseadvisors.com Subject: Re: [AccessD] SPAM-LOW: Re: DBF & Access: "external table is not inthe expectedformat" It's coming from some shrinkwrapped management app they bought. They don't know what version of .dbf file it is producing. They don't know much of anything, really. -C- ---------------------------------------- From: "John W. Colby" Sent: Friday, September 09, 2005 1:21 PM To: "'Access Developers discussion and problem solving'" Subject: SPAM-LOW: Re: [AccessD] DBF & Access: "external table is not in the expectedformat" Have you asked the client what application (and version) the table is from? John W. Colby www.ColbyConsulting.com Contribute your unused CPU cycles to a good cause: http://folding.stanford.edu/ -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Christopher Hawkins Sent: Friday, September 09, 2005 3:08 PM To: accessd at databaseadvisors.com Subject: [AccessD] DBF & Access: "external table is not in the expectedformat" All, This is driving me nuts. A client needs me to be able to link to their .dbf data file from Access. Every time I try to link or import, I get the error message: "external table is not in the expected format" I've tried searching Microsoft's site and have come up with little so far. I'vetried linking and connecting with DBASE5, III and IV. I'm not sure what else to try. Has anyone else seen this problem before? -C- -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com