Kathleen
Tue Dec 05 08:51:27 CST 2006
http://www.carlprothman.net/Default.aspx?tabid=90#ODBCDriverForExcel
--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web:
http://www.spiderwebwoman.com/resources/
"Bill Beshlian" <BillBeshlian@discussions.microsoft.com> wrote in message
news:27B35DF5-F45C-4301-99F3-63A96BE7697B@microsoft.com...
>I had the system DSN created and put the following connection string in the
> global.asa file:
>
> '--Project Data Connection
> Page("initial_injury_reports.asp_ConnectionString") = "DRIVER={Microsoft
> Excel Driver (*.xls)};DBQ=URL=iod/initial_injury_reports.asp"
> FrontPage_UrlVars(3) = "initial_injury_reports.asp_ConnectionString"
> connect_string = "dsn = IODWC"
> '--
>
> Still no luck. If anyone knows where I can find a good tutorial on this
> let
> me know. TIA.
>
> Bill Beshlian
> "Thomas A. Rowe" wrote:
>
>> You don't create a File Data Source, you have to connect to the System
>> DSN that your webmaster
>> created. You may not be able to actually select, in which case you would
>> have to manually modify
>> your current global.asa file to use the System DSN connection.
>>
>> --
>> ==============================================
>> Thomas A. Rowe
>> Microsoft MVP - FrontPage
>>
>>
http://www.Ecom-Data.com
>> ==============================================
>>
>>
>> "Bill Beshlian" <BillBeshlian@discussions.microsoft.com> wrote in message
>> news:4FB126D3-3308-4B2A-993D-56BC7CDD4F6A@microsoft.com...
>> > David,
>> >
>> > The Webmaster created a system DSN like you suggested and it looks lke
>> > it
>> > did not work. I tried to create a File Data Source and when I try to
>> > use it
>> > I get this error:
>> >
>> > "You cannot use ODBC to import from, export to, or link to an external
>> > Microsoft Jet or ISAM database table to your database"
>> >
>> > Thanks,
>> >
>> > Bill
>> >
>> > "David Berry" wrote:
>> >
>> >> Have your web administrator create an System DSN name in the ODBC
>> >> control
>> >> panel on the web server then try it using the name they create.
>> >>
>> >>
>> >> "Bill Beshlian" <BillBeshlian@discussions.microsoft.com> wrote in
>> >> message
>> >> news:76A8B871-F9A7-4FC1-86FE-D45E56887823@microsoft.com...
>> >> > David,
>> >> >
>> >> > I was trying to create a new database connection through Form
>> >> > Properties.
>> >> > I
>> >> > follow the setps to add a connection and select "Network connection
>> >> > to
>> >> > database sever" radio button. After I am done configuring the
>> >> > "Advanced..."
>> >> > settings, I select OK, comback to the "New Database Connection"
>> >> > window and
>> >> > the OK button is still grayed out. Will I need to contact our
>> >> > Webmaster
>> >> > to
>> >> > create the System DSN name? Currently, I only have access to the
>> >> > web
>> >> > folders
>> >> > for my department.
>> >> >
>> >> > Bill Beshlian
>> >> >
>> >> > "David Berry" wrote:
>> >> >
>> >> >> What steps are you using to connect? Did you create a System DSN
>> >> >> name on
>> >> >> the web server that points to the database?
>> >> >>
>> >> >>
>> >> >> "Bill Beshlian" <BillBeshlian@discussions.microsoft.com> wrote in
>> >> >> message
>> >> >> news:FA6C84D2-95AE-483E-BD06-F19D0DA4AE04@microsoft.com...
>> >> >> > Thomas,
>> >> >> >
>> >> >> > Sounds like that would solve a major connectivity issue I was
>> >> >> > asked to
>> >> >> > fix.
>> >> >> > For some reason, I cannot get the connection to the external
>> >> >> > database
>> >> >> > to
>> >> >> > work.
>> >> >> >
>> >> >> > Bill Beshlian
>> >> >> >
>> >> >> > "Thomas A. Rowe" wrote:
>> >> >> >
>> >> >> >> Why not just write it directly to the Access database to start
>> >> >> >> with?
>> >> >> >>
>> >> >> >> --
>> >> >> >> ==============================================
>> >> >> >> Thomas A. Rowe
>> >> >> >> Microsoft MVP - FrontPage
>> >> >> >>
>> >> >> >>
http://www.Ecom-Data.com
>> >> >> >> ==============================================
>> >> >> >>
>> >> >> >>
>> >> >> >> "Bill Beshlian" <BillBeshlian@discussions.microsoft.com> wrote
>> >> >> >> in
>> >> >> >> message
>> >> >> >> news:02C65B31-817D-49DF-854C-7672B3029414@microsoft.com...
>> >> >> >> > My website populates and Excel spreadsheet which I can display
>> >> >> >> > as an
>> >> >> >> > active
>> >> >> >> > server page. For now, I open the asp, save it as an Excel
>> >> >> >> > spreadsheet,
>> >> >> >> > link
>> >> >> >> > it to an Access database then view the link spreadsheet in
>> >> >> >> > Access to
>> >> >> >> > make
>> >> >> >> > sure everything transferred. What I want to to is take this
>> >> >> >> > asp and
>> >> >> >> > create a
>> >> >> >> > function or macro where I press a commmand button and it does
>> >> >> >> > this
>> >> >> >> > automatically for me. I know my process my big challenge is
>> >> >> >> > what to
>> >> >> >> > use to
>> >> >> >> > create this function/macro. Any suggestions are appreciated.
>> >> >> >> > TIA.
>> >> >> >> >
>> >> >> >> > Bill Beshlian
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
>>
>>