Transfer Excel file from a Web Server to Local Server

[Bill Beshlian]

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

 

[Thomas A. Rowe]

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]

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

 

[David Berry]

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]

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]

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.

 

[Thomas A. Rowe]

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
==============================================

 

[Kathleen Anderson [MVP - FrontPage]]

http://www.carlprothman.net/Default.aspx?tabid=90#ODBCDriverForExcel

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/