1

Topic: the table from server SQL a macro

How it to make a macro? Hands I know as, and here a macro that that  as.

2

Re: the table from server SQL a macro

For those who wants to help, but did not understand that is written:
How here this article https://support.office.com/ru-ru/articl … ABAAA=2010 to make  on vba?

3

Re: the table from server SQL a macro

So a macro or on VBA? [spoiler] Learn to formulate already unambiguously, not in a kindergarten... [/spoiler]

4

Re: the table from server SQL a macro

Akina, well as though macroes are written on vba...

5

Re: the table from server SQL a macro

BlackeAngel , on VBA write units. And macroes are macroes, for them even the tab with the same name exists. It not the Ex-fur-tree where any idiot units decided to name macroes because of absence last.

6

Re: the table from server SQL a macro

Akina, h'm. Did not know, what exactly all so is bad. Then the unit on vba.

7

Re: the table from server SQL a macro

Variant 1 (idle time): through DoCmd. TransferDatabase with TransferType: = acLink.
Variant 2 (more difficult): through DAO.database. CreateTableDef with assignment .Connect and.SourceTableName.
Variant 3: to similarly variant 2, but through ADOX.

8

Re: the table from server SQL a macro

Akina, the first variant we consider?

9

Re: the table from server SQL a macro

Yes ... Make demanded at first a macro - there for each field it is possible to cause help yes to esteem. And then you will transfer all it in pure VBA.

10

Re: the table from server SQL a macro

did not become, simply super data with a server as it is written here http://www.vb-helper.com/howto_ado_impo … erver.html