Transfer Spreadsheet to a Web Server???

[HHung1977]

Hello All - I currently have a database with a module that manipulates some data from Oracle and then writes the data into a table. I want to export the table to a web server, but when I use the Transfer Spreadsheet method I keep receiving a message stating, “Run-Time 3651 error Invalid Internet address” However, I know that the address is correct, any suggestions?

DoCmd.TransferS preadsheet acExport, 8, "FINAL_DAIL Y", "http://webnet/bcnet/Documents/StrategicOps/Analysis/AutomatedAdjust ment/TEST", True, "SURVEY_RECORDS "

thank you,
Helen

[Dököll]

Hello All - I currently have a database with a module that manipulates some data from Oracle and then writes the data into a table. I want to export the table to a web server, but when I use the Transfer Spreadsheet method I keep receiving a message stating, “Run-Time 3651 error Invalid Internet address” However, I know that the address is correct, any suggestions?

DoCmd.TransferS preadsheet acExport, 8, "FINAL_DAIL Y", "http://webnet/bcnet/Documents/StrategicOps/Analysis/AutomatedAdjust ment/TEST", True, "SURVEY_RECORDS "

thank you,
Helen

Hello, HHung1977!

Sorry you're having this problem, letting you know to stay tuned for added support. Not sure how to do this.

Also, I am not sure if this makes sense, but do you have an always on internet access when you try this?

In a bit!

[HHung1977]

Dököll, thank you for your reply….

I know that I can successfully navigate to the path using Windows Explorer and then copy and paste the file manually into the appropriate web server folder. I just really need a way to replicate that in code, I guess it does not have to be the transfer spreadsheet method. Any other suggestions?

I’m not totally sure what you meant by, “do you have an always on internet access when you try this?” Can you please clarify and I will try to answer?

Thanks again for your help!

[Nathan H]

Dököll, thank you for your reply….

I know that I can successfully navigate to the path using Windows Explorer and then copy and paste the file manually into the appropriate web server folder. I just really need a way to replicate that in code, I guess it does not have to be the transfer spreadsheet method. Any other suggestions?

I’m not totally sure what you meant by, “do you have an always on internet access when you try this?” Can you please clarify and I will try to answer?

Thanks again for your help!

Just jumping in to say that I have struggled with that issue before, and eventually went to posting XML files instead using Application.Exp ortXML. It took some reconfiguring, but the transfer of tables back on forth on the web is really smooth via this method...

[Nathan H]

Just jumping in to say that I have struggled with that issue before, and eventually went to posting XML files instead using Application.Exp ortXML. It took some reconfiguring, but the transfer of tables back on forth on the web is really smooth via this method...

There is also thinking down "ftp" method rather than transfer method. I've also used this in the past and it works ok:

http://www.databasejou rnal.com/features/msaccess/article.php/3513061

[HHung1977]

Nathan – Thank you for your assistance….

I think that posting the file as an XML document could be an option. However, I just tried writing the data into Excel and then saving it as XML Spreadsheet and a “Web File Properties” popup opens that requires various data points. (E.g. Author name, Title, etc, etc…) Is there a way around this?

I also looked at the FTP code and being a newbie I don’t fully understand it, but if it will allow me to copy the file from a network share and paste it to a web server folder then that will fulfill my needs. Will the FTP code do that?

Thank you,
Helen

[Nathan H]

Nathan – Thank you for your assistance….

I think that posting the file as an XML document could be an option. However, I just tried writing the data into Excel and then saving it as XML Spreadsheet and a “Web File Properties” popup opens that requires various data points. (E.g. Author name, Title, etc, etc…) Is there a way around this?

I also looked at the FTP code and being a newbie I don’t fully understand it, but if it will allow me to copy the file from a network share and paste it to a web server folder then that will fulfill my needs. Will the FTP code do that?

Thank you,
Helen

Helen,

What version of Access are you using?

N

[HHung1977]

MS Access 2003 version 11.0

Thank you!

[HHung1977]

Does anyone have any suggestions for me?

Thank you,
Helen

[Denburt]

Nathan – Thank you for your assistance….

I think that posting the file as an XML document could be an option. However, I just tried writing the data into Excel and then saving it as XML Spreadsheet and a “Web File Properties” popup opens that requires various data points. (E.g. Author name, Title, etc, etc…) Is there a way around this?

I also looked at the FTP code and being a newbie I don’t fully understand it, but if it will allow me to copy the file from a network share and paste it to a web server folder then that will fulfill my needs. Will the FTP code do that?

Thank you,
Helen

The following may help with the excel issue. I am sure you can probably get around this prompt using VBA code if you need too.

Display the Properties dialog box when saving workbooks
To help organize your workbooks so that you can find them easily later, you can set file properties for the active workbook. If you want to be reminded to set file properties for every workbook you create, you can have Microsoft Excel display the Properties dialog box when you save a workbook for the first time.

For more information about file properties and their purpose, click About file properties in the See Also section of this topic.

On the Tools menu, click Options, and then click the General tab.
Select the Prompt for workbook properties check box.
Note The Properties dialog box will be displayed after you click Save in the Save As dialog box whenever you save a file for the first time, or when you click Save As on the File menu to save the file with another name.

If your goal is for an automated solution for uploading then you have a task at hand. I am sure you can handle it though, just review the information at the link Nathan provided then post back with any questions. I will gladly help any way I can although my time is always so limited.