No announcements
Found 2541928 threads
-
13 VotesImporting Access 2010 tables to SQL Server 2008 R2
I just renamed the file that Access 2010 created from *.accdb to *.mdb, and SQL Server import wizard was able to open it and import the data.Answered | 17 Replies | 75467 Views | Created by Floatplane65 - Saturday, July 24, 2010 5:09 PM | Last reply by AHMED ALRWIMY - Friday, April 3, 2020 10:16 AM
-
3 Votes
Simple Task - Get table from Access 2010 into Sql Server 2008
Access 2010 should be able to talk to SQL 2008 R2 and vice-versa -- without any difficulties whatsoever.Answered | 7 Replies | 21673 Views | Created by davestech - Saturday, July 24, 2010 4:47 PM | Last reply by OptimalSolutions - Tuesday, February 22, 2011 12:58 PM -
0 Votes
Access 2010 to SQL Server 2008 R2 Dev
We are working on adding SQL Azure related blogs to SSMA blog site, so that users can find all SQL Server/SQL Azure related migration information in one place.Answered | 4 Replies | 9594 Views | Created by techiegz - Tuesday, March 8, 2011 12:22 AM | Last reply by techiegz - Wednesday, March 16, 2011 5:38 PM -
0 Votes
Export SQL server 2008 R2 to Access 2010
Hello, Did you select "Microsoft Access" provider under "choose a Destination" page of Import/Export Wizard?Answered | 1 Replies | 5781 Views | Created by japowell - Thursday, July 11, 2013 4:19 PM | Last reply by Fanny Liu - Thursday, July 18, 2013 7:44 AM -
2 Votes
Table partitioning in SQL server 2008 R2
CHECK THIS LINK http://blogs.msdn.com/b/manisblog/archive/2009/01/18/easy-table-partitions-with-sql-server-2008.aspxAnswered | 9 Replies | 14137 Views | Created by VenkatABC - Sunday, March 25, 2012 3:07 PM | Last reply by TSMurphy1234 - Friday, March 28, 2014 7:02 PM -
0 Votes
SQL Server 2008 R2
What is SQL Server 2008 R2?Answered | 3 Replies | 11506 Views | Created by SQLFanatic - Thursday, August 19, 2010 3:44 PM | Last reply by Ashish Kumar Mehta - Thursday, August 19, 2010 5:29 PM -
0 Votes
SQL SERVER 2008 R2 REMOTE ACCESS
So, I understand that you have the Access DB application on all other computers which needs to connec to SQL Server DB on Computer 1?Answered | 2 Replies | 8243 Views | Created by Ajay Singh Bhanuka - Saturday, September 3, 2011 7:13 AM | Last reply by Chaitanya Medikonduri - Tuesday, September 6, 2011 10:01 AM -
1 Votes
How to import dbf file data into Sql Server r2 2008
The SQL Server Import and Export Wizard in SQL Server does not support importing from, or exporting to, dBASE or other DBF files.Answered | 1 Replies | 20794 Views | Created by SP Assest - Saturday, May 21, 2011 6:13 AM | Last reply by Mr. Wharty - Saturday, May 21, 2011 7:46 AM -
0 Votes
Copy or Import database from SQL 2008 R2 to SQl 2008
Hi There, how can we import/copy the database of sql2008R2 to sql 2008 Hello, Take script of ...Answered | 15 Replies | 2073 Views | Created by Rahul81 - Monday, April 14, 2014 10:22 AM | Last reply by Vanchan - Tuesday, April 15, 2014 12:15 PM -
0 Votes
Biztalk 2010 and SQL Server 2008 under Server 2008 R2 SP1
Below is the ...Answered | 7 Replies | 1810 Views | Created by krillin837 - Wednesday, August 14, 2013 4:01 PM | Last reply by Maheshkumar S Tiwari - Wednesday, August 14, 2013 8:27 PM -
0 Votes
Issues with Excel Imports in MS SQL Server 2008 R2: Only the column Names are displayed in the DB table, No data.
http://sql-bi-dev.blogspot.com/2010/08/dynamic-ssis-package-to-import-excel.html http://www.youtube.com/watch?Answered | 4 Replies | 3211 Views | Created by Abhishek Semwal - Monday, July 2, 2012 12:46 AM | Last reply by Koen Verbeeck - Monday, July 2, 2012 12:53 PM -
0 Votes
TFS 2010 support for SQL Server 2008 R2?
HI vs2010junkie, SQL 2008 R2 is fully supported by TFS 2010.Answered | 1 Replies | 12508 Views | Created by vs2015junkie - Thursday, May 6, 2010 11:00 PM | Last reply by ArunRama [MSFT] - Thursday, May 6, 2010 11:24 PM -
0 Votes
Visual 2010 and SQL 2008 r2
Hello, In some project types you can define the "Target Server Version" to an other version then SQL Server 2012, e.g. in SSAS projects.Answered | 1 Replies | 1269 Views | Created by DIEGOCTN - Wednesday, January 8, 2014 2:52 PM | Last reply by Olaf Helper - Thursday, January 9, 2014 6:55 PM -
0 Votes
how to import table from access to sql-server
SQL Server Migration Assistant for Access, which can additionally replace your Access table with a linked table to SQL ...Answered | 2 Replies | 2692 Views | Created by E_gold - Tuesday, May 28, 2013 5:07 PM | Last reply by davidbaxterbrowne - Tuesday, May 28, 2013 5:12 PM -
0 Votes
Import data from excel file into sql server table in sql server 2008 R2 ?
Tasks - > Import Data GUI will open up in data source select excel, select path where excel file is kept...Answered | 1 Replies | 3895 Views | Created by Maggy111 - Tuesday, October 30, 2012 1:02 PM | Last reply by RahulKapoor - Tuesday, October 30, 2012 1:11 PM -
1 Votes
SQL SERVER 2008+SQL SERVER 2008 r2
If you're looking for SQL Server 2008 R2, you can download Express Advanced, which contains both engine and tools, or if you have a local copy of the ...Answered | 2 Replies | 2434 Views | Created by Balaji Sunku - Wednesday, September 3, 2014 5:47 AM | Last reply by Samuel Lester - MSFT - Wednesday, September 3, 2014 6:07 AM -
0 Votes
Import Access 2010 database data into SQL Server 2008
(SSIS)MCITP BI Developer - MCTS SQL ServerAnswered | 1 Replies | 10383 Views | Created by Jigsy50 - Thursday, September 15, 2011 3:48 PM | Last reply by Jason V Campbell - Friday, September 16, 2011 11:12 AM -
0 Votes
Import Function for Access Table To Azure SQL Server?
You can use the SSIS Import/Export Wizard for data transfer from Access to Azure SQL ...Answered | 2 Replies | 2033 Views | Created by Jeffrey Thorn - Monday, March 4, 2013 2:04 AM | Last reply by Kalman Toth - Monday, March 4, 2013 10:09 AM -
0 Votes
SQL Server 2008 R2 and Project Server 2010
it will be documented on TechNet once all the 2010 docs go live next week as part of our virtual launch for Project 2010 on May 12th.Answered | 2 Replies | 12881 Views | Created by John Doe Cal - Wednesday, May 5, 2010 2:47 PM | Last reply by Christophe Fiessinger - Wednesday, May 5, 2010 5:03 PM -
0 Votes
Importing Access 2013 to SQL Server 2008 (Simple Question - Please Help)
Alternatively, you can also try to create a new SSIS package to import the Access data to SQL Server table instead of using the ...Answered | 4 Replies | 7324 Views | Created by Importing Access 2013 to SQL Server 2008 - Friday, September 6, 2013 1:06 PM | Last reply by Mike Yin - Thursday, September 12, 2013 1:47 AM - Items 1 to 20 of 2541928 Next ›
No announcements
