Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
samjesse
Starting Member
8 Posts |
 Posted - 2009-07-10 : 01:10:26
|
| HiI have a table in Access 2000 and want the data into my VS2008 database table. I have sql2008 express installed. I need help on how to do it please.I converted it to an excel sheet but that is about it.thanks |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-07-10 : 04:33:39
|
You don't need to do that, but as you have, just use the Excel as a source and a table as a destination in SSIS, or use OPENQUERY to set a direct link to the excel. Then you can do a simple:select * into openquery('Microsoft.Jet.OLEDB.4.0','Data Source=<your excel>;Extended Properties=Excel 8.0')...[worksheet]$)Here is a good guide:http://support.microsoft.com/kb/321686 |
 |
|
|
|
|
|
getting the data from MS Access 2000 table