Export Access 2013 to sql server 2012

[jassie]

I am trying to determine what the best way is to export Access 2013 data to Sql server 2012 on a daily basis. Thus I have the following questions to ask:

1. Would you describe and/or point to links that would tell me how to accomplish this goal?


2. In the following link:
http://www.mssqltips.com/sqlserverti...to-sql-server/ ,
where is a reference to how to use 'database tools' and to import the data into sql server while the access 2013 database is open.
I want to try what is listed in the link, but I do not see sql server an item to move data to.
Thus can you tell me what is wrong with the link I pointed to and/or tell me how to import Access 2013 data into sql server 2012 on a daily basis?

[ranman256]

I have my SQL tables linked into the access db.
Then I run an append query to add records to SQL tbls.

[jassie]

Can you show me the sql, a better detailed explanation, and/or point to links(urls) on how to accomplish the following tasks you listed above?

I have my SQL tables linked into the access db.
Then I run an append query to add records to SQL tbls.