in reply to DBI::Excel Help Needed

In MS Access, you would be able to get around this problem with this SQL statement: 
SELECT [Tracking Nbr] FROM Kaiser_VRT_Extract_Sac

[download]
Try using square brackets, it might work in Excel also. In general, I like to avoid column names with spaces for this reason.

Replies are listed 'Best First'.
Re: Re: DBI::Excel Help Needed
by T.G. Cornholio (Scribe) on Nov 26, 2002 at 03:18 UTC
    Jupiter,

    This didn't work for me, I tried a few permutations on my own:

    SELECT [Tracking Nbr] FROM Kaiser_VRT_Extract_Sac

    [download]
    Gives:

    SQL ERROR: Bad table or column name '[Tracking Nbr]' has chars not alp
+hanumeric or underscore!

    [download]
    Similar errors occur for:

    '[Tracking Nbr]'
['Tracking Nbr']
"[Tracking Nbr]"
["Tracking Nbr"]

    [download]
    I agree on the avoidance issue, but unfortunately I'm stuck with what I have. When I get connected to the "real" database there's probably not going to be a problem, but it would be nice to do the development in an isolated environment.

    Thanks for the suggestion, let me know if you think of anything else. Anyone know where to look for the answer?

[reply]
[d/l]
[select]

In Section Seekers of Perl Wisdom