Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel file to a temp sql table
Message
From
08/12/2004 09:21:06
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
08/12/2004 09:17:35
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Database:
MS SQL Server
Miscellaneous
Thread ID:
00967657
Message ID:
00967719
Views:
10
>Thank you for you answer.
>I need to tell you more of what I'm trying to do.
>
>I am using Javascript in a asp page on the web.
>I locate the xls file on the system and hold the
>location in a var like the foxpro getfile()
>
>Next I need to compare this file to a table in the sql.
>I was going to send it to sql and do the comparing there,
>but now I think I want to send it to a temp dbf on the server
>and use a foxpro com to do the work.
>
>How to I send the xls file to my temp dir on the server, knowing
>the location of the xls is variable.

>FTP?? or something.

A command as simple COPY FILE can work with variable locations.
copy file (var_origin) to (var_destination)
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Reply
Map
View

Click here to load this message in the networking platform