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:
Import data from Microsoft Access 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?
1. Would you describe and/or point to links that would tell me how to accomplish this goal?
2. In the following link:
Import data from Microsoft Access 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?