Hi, Gary
In ODBC/32 fairy easy to set up. converting to Excel
I wrote VBA code to read table in Access(ODBC by IMAGE or Flatfile)
to writing Excel Open and activate Excel and write Excel column by column
VBA popup Excel and fill the data. It is transparent to Image Table or
Flat file in HP3000 up to 30,000 Records.
Cheers
Peter C.
Paveza, Gary <[log in to unmask]> wrote in message
news:F4B1826B1A21D211AEC5006008207AF402114050@dogbert.csillc.com...
> Okay, I'm about to pull my hair out here, so if anyone around can help me
> with this, I would appreciate it very much!.
>
> I have a database on the HP that is enabled for ODBC access, I know that
it
> works, as I just used it recently. My problem comes with trying to setup
> Windows NT and the data source. Under the odbc datasources in the control
> panel, I have correctly added the User DSN. I have verified this by using
> access to connect to the database (Microsoft Access can use the user DSN
> while Microsoft Excel seems to want to use a file DSN).
>
> Now, from what HP support was telling me, I need to create a file DSN, and
> when I choose the drive, to select the advanced options and add the line
> DSN=<user dsn name>. I've tried this, but 1) it doesn't want to stay, and
> 2) when I edit the DSN manually, and add the line, Excel (or rather
> Microsoft Query), still says that there is no DSN. I seem to recall
needing
> something else in file DSN. Anyone have any ideas?
>
> -------------------------------
> Gary L. Paveza, Jr.
> Technical Support Specialist
> All opinions are mine and not those of my employer
>
|