1

Topic: excel and access as a database

It is necessary to address to the book excel (and access) as to a database.
32bit drivers ODBC do not work on mine 64bit WIN7.
Hence, it is necessary office x64.
How I understood is since 2013? Is 1 a question.
The Internet frightens of incompatibility possibilities, and at me on operation everywhere office 2007.
Advise  the correct line of conduct.

2

Re: excel and access as a database

In that: see
HERE it is written why 32 ODBC drivers do not work on 64 win7
https://knowledge.autodesk.com/support/ … ffice.html
I installed 64 bit office also this problem dared.
There was a following

3

Re: excel and access as a database

muk07;
Work without ODBC, on a straight line,  and without  clings both an ex-fur-tree and itself without any tambourines

4

Re: excel and access as a database

Thanks.
If it is possible,  is hardly more detailed.
I should organize synchronization of tables ms sql server and Excel.
Whether your stated reason can help me?

5

Re: excel and access as a database

it is not necessary wrote:

muk07;
Work without ODBC, on a straight line,  and without  clings both an ex-fur-tree and itself without any tambourines

You are not right tambourines much. (Do not confuse the HARDWARE)

6

Re: excel and access as a database

muk07 wrote:

Thanks.
If it is possible,  is hardly more detailed.
I should organize synchronization of tables ms sql server and Excel.
Whether your stated reason can help me?

You cannot work valuably with Excel from Access ().

7

Re: excel and access as a database

It is glad...

8

Re: excel and access as a database

ROI wrote:

you cannot work valuably with Excel from Access ().

Why? Automation means give very quite good possibilities.

9

Re: excel and access as a database

mds_world wrote:

it is passed...
Why? Automation means give very quite good possibilities.

Well only it is necessary to program much

10

Re: excel and access as a database

muk07 wrote:

It is necessary to address to the book excel (and access) as to a database.

Whence, from what application?

muk07 wrote:

32bit drivers ODBC do not work on mine 64bit WIN7.
Hence, it is necessary office x64.

Fairy tales. MS Jet - it is enough for THIS task.

muk07 wrote:

I should organize synchronization of tables ms sql server and Excel.

is more detailed - a synchronization direction? Under whose initiative? And, whether know, Linked server - and further it...

mds_world wrote:

automation Means give very quite good possibilities.

I even would tell, almost full... It is difficult to invent something, accessible hands and at the same time inaccessible through automation.

ROI wrote:

it is necessary to program much

So after all "both , and "...