By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,124 Members | 2,027 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,124 IT Pros & Developers. It's quick & easy.

Transfer Spreadsheet to a Web Server???

P: 5
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.TransferSpreadsheet acExport, 8, "FINAL_DAILY", "http://webnet/bcnet/Documents/StrategicOps/Analysis/AutomatedAdjustment/TEST", True, "SURVEY_RECORDS"

thank you,
Helen
Dec 18 '07 #1
Share this Question
Share on Google+
9 Replies


Dököll
Expert 100+
P: 2,364
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.TransferSpreadsheet acExport, 8, "FINAL_DAILY", "http://webnet/bcnet/Documents/StrategicOps/Analysis/AutomatedAdjustment/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!
Dec 19 '07 #2

P: 5
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!
Dec 19 '07 #3

Nathan H
100+
P: 104
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.ExportXML. It took some reconfiguring, but the transfer of tables back on forth on the web is really smooth via this method...
Dec 19 '07 #4

Nathan H
100+
P: 104
Just jumping in to say that I have struggled with that issue before, and eventually went to posting XML files instead using Application.ExportXML. 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.databasejournal.com/features/msaccess/article.php/3513061
Dec 19 '07 #5

P: 5
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
Dec 19 '07 #6

Nathan H
100+
P: 104
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
Dec 19 '07 #7

P: 5
MS Access 2003 version 11.0

Thank you!
Dec 19 '07 #8

P: 5
Does anyone have any suggestions for me?

Thank you,
Helen
Dec 21 '07 #9

Denburt
Expert 100+
P: 1,356
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.
Dec 21 '07 #10

Post your reply

Sign in to post your reply or Sign up for a free account.