Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Converting MDB to DBF
Message
From
22/06/2005 09:23:45
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Converting MDB to DBF
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows '98
Network:
Windows 98
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01025422
Message ID:
01025422
Views:
61
Dear Experts

To convert Access MDB to vfp DBF I use following codes
lcmdb=("c:\HJSDB.mdb")
Store SQLSTRINGCONNECT(;
	'DBQ='+lcmdb+';'+;
	'Driver={Microsoft Access Driver (*.mdb)}');
	TO gnConnHandle

If gnConnHandle <= 0
	= MESSAGEBOX('Cannot make connection', 16, 'SQL Connect Error')
	Return
Else
Endif

=SQLEXEC(gnConnHandle,"select * from lcmdb;","myCURSOR")

Select myCURSOR
Copy TO C:\PHONE.DBF
But it creates following error message
Alias "MYCURSOR" is not found
and debugger stops on second last line

Select myCURSOR

What is wrong? Please modify or suggest another codes for me

Thanks in advance
Next
Reply
Map
View

Click here to load this message in the networking platform