0

Hello,

May be the there is a very simple solution for my problem, but I am stuck on this for 2 days already. May be I had been looking at the wrong places...I would really appreciate any kinds of helps....feeling really frustrated right now.

You see, for my project at first I have to convert a MS Access table to SQL Server (2008). No matter how I am searching, I am only getting results for converting a MS Accss 'database' to a SQL 'database'. But our company already has an existing SQL database. I just want to convert one MS Access 'table' to SQL Server (2008) 'table'.

Any suggestions, please? Thank you in advance!!!!

PS: sorry if I've posted my thread in wrong place :/

4
Contributors
6
Replies
7
Views
5 Years
Discussion Span
Last Post by Walahh
1

I am only getting results for converting a MS Accss 'database' to a SQL 'database'. ...... I just want to convert one MS Access 'table' to SQL Server (2008) 'table'.

What is the difference ?

Votes + Comments
none
0

If I use the Import and Export wizard then I have to create a whole NEW database in SQL server. But our project already has an existing database. I am looking for a way to convert/marge that one single Access table to SQL table....without creating a new database.

Thank you!!!!

1

If I use the Import and Export wizard then I have to create a whole NEW database in SQL server. But our project already has an existing database. I am looking for a way to convert/marge that one single Access table to SQL table....without creating a new database.

Thank you!!!!

You can create a new database (if you have the necessary rights), and get the table from there:

select * into tablename from newdb.dbo.tablename

If you don't have the necessary rights on the server, then I guess you can always create the table manually and use Access with an Append Query to insert the data on a linked table, but it's way easier to just create a new db, get your data and drop the db.

0

Thank you for the idea.....i didn't know I can do that. :)

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.