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

SQL dbase to Access

P: 10
hello all,
i'm new in access and i need some help. here's the scenario, i need to copy a table in sql server to access. then edit the copied table and update the table in the sql server of any changes made from the table. the sql server is a third party so i cant do anything much from there. and i need to do this using access macro.
what im doing now is copy the table from sql server to ms excel then to access. is there any other way to do this using macro? any help is greatly appreciated.
thanks!
Dec 14 '06 #1
Share this Question
Share on Google+
7 Replies


100+
P: 1,646
hello all,
i'm new in access and i need some help. here's the scenario, i need to copy a table in sql server to access. then edit the copied table and update the table in the sql server of any changes made from the table. the sql server is a third party so i cant do anything much from there. and i need to do this using access macro.
what im doing now is copy the table from sql server to ms excel then to access. is there any other way to do this using macro? any help is greatly appreciated.
thanks!
Hi
You can link to the sql table from access or import to an access table from sql server.
Dec 14 '06 #2

MMcCarthy
Expert Mod 10K+
P: 14,534
Hi
You can link to the sql table from access or import to an access table from sql server.
BTW you will need an odbc or DSN connection to the SQL Server to do this.

When the Link or Import wizard opens scroll down the file types until you select odbc types and the odbc wizard will open.

Mary
Dec 14 '06 #3

NeoPa
Expert Mod 15k+
P: 31,660
If you need more help (with updating the data in Access or uploading the data back to SQL Server) then you need to make your question clearer.

MODERATOR
Dec 14 '06 #4

P: 10
thanks! i already linked the table from sql to access. its working fine! but what if i need to make a local copy of the linked table. i tried the copyobject from macro, it has been copied successfully but it is still linked. how can i copy the linked table and make it a local copy of access? (the table will be edited and be used as a reporting tool but as of now, updating of sql server is a no go so i need to make a local copy)

thanks again!

p.s. need it to be done in macro.
Dec 15 '06 #5

MMcCarthy
Expert Mod 10K+
P: 14,534
thanks! i already linked the table from sql to access. its working fine! but what if i need to make a local copy of the linked table. i tried the copyobject from macro, it has been copied successfully but it is still linked. how can i copy the linked table and make it a local copy of access? (the table will be edited and be used as a reporting tool but as of now, updating of sql server is a no go so i need to make a local copy)

thanks again!

p.s. need it to be done in macro.
The easiest way is to use the Access query window and set the query to a make table query. Simply create a new table based on the link table. This will create a local access version of the table. If you need it in a macro simple run the query in the macro.

Mary
Dec 15 '06 #6

P: 10
Thanks a lot Mary! it works great!
Dec 15 '06 #7

MMcCarthy
Expert Mod 10K+
P: 14,534
Thanks a lot Mary! it works great!
You're welcome.
Dec 15 '06 #8

Post your reply

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