May 14, 2013 at 6:31 am
When linking your access tables to SQL what issues would you make sure to deal with before linking the tables?
May 14, 2013 at 7:51 am
todd.ayers (5/14/2013)
When linking your access tables to SQL what issues would you make sure to deal with before linking the tables?
Don't you mean before linking your SQL table to Access? Meaning you have a table in SQL Server that you want to be available in SQL Server.
Not sure what you mean about resolving issues prior to this.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
May 14, 2013 at 8:04 am
Well, I have tables in access that I am wanting to put into the SQL server so that I can use Access as the Front End and SQL Server as the back end.
May 14, 2013 at 8:35 am
todd.ayers (5/14/2013)
Well, I have tables in access that I am wanting to put into the SQL server so that I can use Access as the Front End and SQL Server as the back end.
I would use the data import SSIS wizard in SSMS. Then add that as a linked table in Access.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
May 14, 2013 at 11:22 am
Ok, I used the SSMA and migrated over a test db with some tables but now I cannot delete those tables because they are linked to each other and shares keys and what not. How can I remove those tables?
May 14, 2013 at 11:28 am
nvm I figured it out.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply