The reason you are experiencing problems is the value you
are passing isn't defined.
xlWindows is a constant with a numeric value (i.e.
something like 4)
For your code to work you'll either need to pass the
actual number or declare a bunch of constants
CONST xlWindow = 1
CONST xlDelimitted = 8
Note: I don't know the values for the above constants
these are just example.
Also, Excel doesn't require that you call the object
model with named parameters (i.e. Origin:=). This is a
nicety allowing for you to change the order of the
parameters. You could call them in the expected order
without this convention.
An example would be:
Wookbooks.opentext "O:\myfile.txt", xlWindows,.....
Principal Architect, Business Intelligence
Vice President of Marketing
Professional Association for SQL Server (PASS)
More SQL Server Education than anywhere else....Pre-
Conference Seminars including one on DTS!
Don't Miss the PASS Community Summit November 19-22!
More new SQL Server sessions by MVPs, Microsoft and the
PASS SQL Server User Community.
Take part in the conference and community run by Users
Visit Us at http://www.sqlpass.org
>I'm trying to import a text file into Excel, manipulate
the text file, and
>import it into SQL. I have a VB program that works
fine, but DTS is giving
Quote:>me a headache. Every time I try to parse the script I
get an error that
>reads "Expected Statement at line XX". I've narrowed
the problem down to
>how Excel takes parameters. Excel wants the parameter
name, a semicolon, an
Quote:>equal sign, and then the value (ie. Origin:=xlWindows).
I can get the
>script to parse if I remove all of the semicolons but
then the Excel methods
>fail. Does anyone have any suggestion on how to get
>Here is one of the methods I am having difficulties with:
>Space:=True, Other:=False, FieldInfo:=Array(Array(1, 1),
>Array(3, 1), Array(4, 1), Array(5, 1), Array(6, 1), Array
(7, 1), Array(8,
>1), Array(9, 1))