documentation on spreadsheet import?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

david epsom dot com dot au - 26 Aug 2004 02:38 GMT

Does anyone know where to look / has anyone seen documentation
of the use of $ instead of ! when using Jet SQL to import from
a spreadsheet?

(Excel would refer to a cell range as 'mypage!a1:a5', but I find
that my INSERT query will only work with 'mypage$a1:a5')

(david)

Reply to this Message

John Nurick - 26 Aug 2004 06:33 GMT

Hi David,

Try
http://www.microsoft.com/accessdev/articles/daoconst.htm

>Does anyone know where to look / has anyone seen documentation
>of the use of $ instead of ! when using Jet SQL to import from
[quoted text clipped - 4 lines]
>
>(david)

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Reply to this Message

david epsom dot com dot au - 27 Aug 2004 00:11 GMT

Thanx! I was particularly interested in the reference to FTP
- I thought there had been some way to FTP data, but I haven't
been able to find anything for years.

Also chagrined to notice that I'm using .XLS instead of #XLS,
and have been for years -- there must have been an unheralded
change to Jet that made that possible.

(david)

> Hi David,
>
[quoted text clipped - 14 lines]
>
> Please respond in the newgroup and not by email.

Reply to this Message

John Nurick - 27 Aug 2004 06:16 GMT

>Thanx! I was particularly interested in the reference to FTP
>- I thought there had been some way to FTP data, but I haven't
>been able to find anything for years.

I'd be interested to hear if it works!

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Reply to this Message