Just a thought: are any of your column names to long for dBase? --- Ted Wolfley <[EMAIL PROTECTED]> wrote:
> Hi, > > Has anyone else been having problems exporting a table to .dbf file. > This was working. I hadn't updated the server for awhile until last > week. > > When I run the following code on a local database, nothing is happening > and I don't receive a error message. There are 140 columns and 781 > records in the table. The BDE Administrator in Control Panel has the > dbf setting set to version 4. When I try the import/export from the > toolbar, I get "Error of data export.: Too many fields in Table Create. > Table does not exist. Table: D:\databases\smith\test.dbf". > > I can export using csv format with out an error. > > SET VAR vfilename='usa1.dbf' > > GATEWAY EXPORT dbf .vfilename SELECT * FROM de_card > > When I try the export/import on the network server, I get the following > error "Error of data export.: BLOB not opened." > > Ted Wolfley > Database/Internet Programmer > The Ogden Group of Rochester > > 5637 West Henrietta Road > > West Henrietta, NY 14586 > phone: (585) 321 1060 x23 > fax: (585) 321 0043 > [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > > www.ogdengroup.com <http://www.ogdengroup.com/> > > > Albert Berry Management Consultant RR2 - 1252 Ponderosa Drive Sparwood BC, V0B 2G2 Canada (250) 425-5806 (250) 425-7259 (708) 575-3952 (fax) [EMAIL PROTECTED]
