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 |
|
rohit04413
Yak Posting Veteran
72 Posts |
 Posted - 2011-07-21 : 06:45:24
|
| While trying to import data from excel 2003 to sql server 2005, i am getting an error screeshot here: [url]http://postimage.org/image/c7whvso4/[/url]PLease help. |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-07-21 : 07:03:16
|
| What's the error? I'm not going to follow a link.Usually it's because the datatypes are wrong, can't find the source table or trying to import beyond the end of data.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-07-21 : 07:22:14
|
| how are you importing? export import wizard or OPENROWSET?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
rohit04413
Yak Posting Veteran
72 Posts |
Posted - 2011-07-21 : 08:54:06
|
quote:
Originally posted by visakh16
how are you importing? export import wizard or OPENROWSET?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/
I am importing with management studio using import wizard. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-07-21 : 10:12:05
|
| can you tell which excel connector you're using? JET or ACE?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
rohit04413
Yak Posting Veteran
72 Posts |
Posted - 2011-07-26 : 04:15:47
|
quote:
Originally posted by visakh16
can you tell which excel connector you're using? JET or ACE?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/
I don't know the type of connector. I am new to SQL.I am just using import wizard of SQL Server management studio . |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-07-26 : 13:22:46
|
| oh ok so its jet one i guessis it 64 bit machine?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
rohit04413
Yak Posting Veteran
72 Posts |
Posted - 2011-08-04 : 02:47:17
|
quote:
Originally posted by visakh16
oh ok so its jet one i guessis it 64 bit machine?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/
No its not a 64 bit machine.Any solution?? |
|
|
|
|
|
|
Importing Records from Excel 2003 to sql 2005