Link SQL Server Azure to On Premise SQL Server

E

ERC2

New Member
Joined
Sep 12, 2011
Messages
33
I am building a Access Web app in office 365 (something I have never done before). I think by default the tables created in the app are stored in sql server azure. Can I specify or define the names of the sql server azure and link to our on-site sql server? I am trying to sync the data tables on the two servers. Right now it looks like I can import the tables from on premise into the web app, but I want this to be an automated two-way process. Any advice? Thanks in advance.
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
You must log in or register to reply here.

Similar threads

S
  • Question Question
ACCESS, VBA: Fetch data from sql server and paste it into local table.
Replies
3
Views
2K
Micron
M
J
  • Solved
Linked tabled to my SQL SERVER takes a lot of time to load
Replies
3
Views
1K
JRSam
J
O
  • Question Question
to link the tables in MS Access FE from SQL Server and then share FE for multi user environment
Replies
1
Views
1K
ranman256
ranman256
J
  • Question Question
ODBC--call failed #241
2
Replies
14
Views
5K
Micron
M
D
  • Question Question
Excel Office 365/ Excel Linked workbooks on network drive.
Replies
0
Views
345
dcovert
D

Forum statistics

Threads
1,223,228
Messages
6,170,874
Members
452,363
Latest member
merico17

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top