GETFILE & IMPORT FROM don't like each other

[Winston4]

I am trying to have the user select an Excel file (GETFILE) which my code then tries to do an IMPORT FROM to load the file into a new table. I get a "File does not exist" on the IMPORT FROM line. Any ideas?

Here are the two lines of code

File_import = GETFILE("Excel *.xls:XLS","","Import",0,"Select the file to import")

and

IMPORT FROM Filename_import TYPE XL8
(I have also tried several other lines ex:IMPORT FROM File_import DATABASE Database_name NAME Table_import TYPE XL8

Thanks for any help here.

 

[bborissov]

What you try is to imort a file named Filename_import.XLS
You must use either a name expression ether macro (I oprefer first):

File_import = GETFILE("Excel *.xls:XLS","","Import",0,"Select the file to import")

IMPORT FROM (Filename_import) TYPE XL8

*** or
*** IMPORT FROM &Filename_import TYPE XL8

with macro expression you will have a problems if Filename_import has spaces in name.

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

 

[Mike Lewis]

You're also using two different variables for the same file. It seems to me you need this:

File_import = GETFILE("Excel *.xls:XLS","","Import",0,"Select the file to import")

IMPORT FROM ([b]File_import[/b]) TYPE XL8

Also, you should check to see if the user cancelled out of the dialogue:

File_import = GETFILE("Excel *.xls:XLS","","Import",0,"Select the file to import")
IF NOT EMPTY(File_import)
  IMPORT FROM (File_import) TYPE XL8
ENDIF

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

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

 

[Winston4]

Thanks guys. That is what I needed. Been long time since I coded in FoxPro and my syntax is quite rough.