Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with importing excel file into a dbf
Message
 
To
17/09/2004 14:28:38
Eric Gauthier
Transcontinental Interweb (Montreal)
Boucherville, Quebec, Canada
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00943513
Message ID:
00943568
Views:
21
Since you mentionned you needed to import an Excel sheet into a table, I made the assumption that the user's computer had Excel installed in order to create the Excel sheet and the second reason I made that assumption would be this line of code you posted, which makes use of the Excel driver.
strconn = "Driver={Microsoft Excel Driver (*.xls)}; DBQ="+ALLTRIM(thisform.filein)+";ReadOnly=1"
>DOH, sorry i dont mention that I cant use excel.application because i dont know if the PC where this program is installed have excel or office...
>
>I try to use Alter table after this but all informations in the table are lost.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform