Opening dbase files 1

[SBTBILL]

Anybody know of a way to open a dbase dbf with out turning it into a fox dbf?

Bill Couture

 

[JRB-Bldr]

Many DBF files (not all) can be opened within Excel

Good Luck,
JRB-Bldr

 

[bborissov]

Easy:

SET CPDIALOG OFF 
USE YourDbaseDBF

*** or
USE YourDbaseDBF SHARED IN 0

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP

 

[Mike Lewis]

Bill,

Just go ahead and open it. But take care to cancel the Code Page prompt, and avoid modifying the structure or creating indexes within VFP.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk

 

[Dan Freeman]

DO NOT do this if a memo field is involved. VFP *will* convert the memo field and alter the DBF's header to indicate it's a Fox memo field.

 

[SBTBILL]

Indexs and memo are the issue any idea how to open those things?

Bill Couture

 

[DougHennig]

Hi Bill.

The best way to do this is to use the dBase ODBC driver. You can use SQL passthrough commands, create a remote view, or use a CursorAdapter. I do this all the time and it works great.

Doug

 

[Mike Lewis]

Bill,

Or, you could take a look at Codebase (

http://www.codebase.com).

It lets you do just about anything with a dBASE file, including full support for indexes and memos. Not particular cheap, but it's a solid product with a long history.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk

 

[SBTBILL]

Never had much luck with pass throughs, have used ADO for SQL a lot. Can you post a sample of the code?

Thanks
Bill Couture
http:\\

http://www.sbtbill.com

 

[DougHennig]

Hi Bill.

Here's some sample code off the top of my head:

lnHandle = sqlstringconnect('driver=Microsoft dBase Driver (*.dbf);dbq=C:\Location of DBF Files')
if lnHandle < 0
* handle error
return
endif
lnResult = sqlexec(lnHandle, 'select * from SomeTable where SomeClause', 'DesiredCursorName')
if lnResult = 1
* do something with the cursor
endif
sqldisconnect(lnHandle)

Doug

 

[SBTBILL]

Thanks Doug I'll give it a try this weekend.

Bill Couture