IMPORTING DATA PROBLEM WHIT VISUAL FOXPRO 5

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DIEGO TESTA - 29 Jun 2004 14:06 GMT

HELLO I HAVE A PROBLEM IMPORTING DATA BECAUSE ALWAYS HAVE THE SAME ERROR AND SAY FILE NOT FOUND

I HAVE SEVERAL EXCEL FILES WITH DIFERENTS NAMES LIKE 393.XLS OR 159.XLS AND THATS THE CODE

IM EXECUTIN SOME CODE AND..
ARCH_NEW = "C:\IMPORT\393.XLS"

IMPOR FROM ARCH_NEW TYPE XL5

AFTER THAT SAY FILE NOT FOUND. SOMEONE CAN TELLME WHY DOESN`T WORK THIS CODE.
THANKYOU
DIEGO

Reply to this Message

Cindy Winegarden - 29 Jun 2004 16:44 GMT

> ARCH_NEW = "C:\IMPORT\393.XLS"
>
> IMPOR FROM ARCH_NEW TYPE XL5
>
> AFTER THAT SAY FILE NOT FOUND.

Hi Diego,

Visual FoxPro thinks you want to import a file named Arch_New. You need to
indicate that VFP should import a file with a name that is held by the
variable Arch_New. To do this you use a "name expression" which is indicated
by parenthesis.

Arch_New = "C:\Import\393.xls"
Import From (Arch_New) Type XL5

Signature

Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy.winegarden@mvps.org www.cindywinegarden.com

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...