I?m looking for some help before i loose the plot.
Basically I am looking to make an external reporting tool in Access that in part uses a data table from our SQL database. What i want to be able to achieve by some means is a way to import this table from SQL to Access on a regular basis to ensure its up to date. Now i am aware i could link that table, but i wish to avoid this, probably making a rod for my own back but there you go.
Is there anyway by the means of a VBA script using ODBC, or such that could be executed from a form to initiate a refresh / replacement of a table from SQL to Access?
Question
Report Monkey
Hi All
I?m looking for some help before i loose the plot.
Basically I am looking to make an external reporting tool in Access that in part uses a data table from our SQL database. What i want to be able to achieve by some means is a way to import this table from SQL to Access on a regular basis to ensure its up to date. Now i am aware i could link that table, but i wish to avoid this, probably making a rod for my own back but there you go.
Is there anyway by the means of a VBA script using ODBC, or such that could be executed from a form to initiate a refresh / replacement of a table from SQL to Access?
For reference
ODBC System DSN = MMSV3.5
SQL Server = sqlserver\mms
SQL DB = ReportsDB
SQL Table = dbo.BinItem
Any help would be greatly appreciated.
Cheers
Ross
Edited by Report MonkeyLink to comment
Share on other sites
3 answers to this question
Recommended Posts