How is the best way to import data into SQL Server Express?

I want to import data into SQL Server Express, from Access, Excel and txt files. I'm creating a decent database, and I must to import these old formated data. When working with few records, I copy and paste directly through Visual Web Developer DB Explorer.

But now I'm dealing with a few more records (40k). I think copy/paste unsafe, slow and unprofessional. I haven't any other interfaces to cont开发者_StackOverflow社区rol SQL server. How can I do that?

Thanks!

There is an "Import and Export Wizard" that comes with SQL Express. It allows you to import from Access, Excel, ODBC, SQL Client etc.

I don't think there's a clear answer but I really think MSACCESS 2000 or higher is a very versatile tool for doing this..

Linking in tables and using Append queries to other linked tables works really well, plus utilizing the power of VBA helps in some cases too (like calling a vba function from query designer (like InStr or Mid etc..) (if your familiar with this)

Does anyone else agree?

The BCP (Bulk Copy) works well for importing into SQL Server: http://msdn.microsoft.com/en-us/library/ms162802.aspx

There is also the "bulk insert" command: http://msdn.microsoft.com/en-us/library/ms188365.aspx which has the caveat that the file must be physically accessible from the server.

Both of these methods can import comma delimited files, so you'd need to be able to create those from your data source.

I recommend loading all the objects from one SQL table into a JSON object and then indexing through an array of object and translating them into the new table. I have some open source MySQL to JavaScript bridge code that can help with this if you need.

In case you have not found a solution to this yet, try http://www.razorsql.com/download_win.html

I am not affiliated with them, but I was looking for this same solution and this is working.