Import excel (2002) to MS SQL 2000

Hello experts.
I have one excel file Texttables and i want to import the Mytext table with columns:TextID,Text,LangID in the MS SQL Table with the same columns.
Any help?
LVL 2
PanosAsked:
Who is Participating?
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
You can do any one of the approaches listed here:

http://support.microsoft.com/kb/321686

Or

SELECT * INTO XLImport4 FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=C:\test\xl_file_name.xls', [excel_sheet_name$])
0
 
RiteshShahCommented:
DTS or Import/Export wizard are your tools to achieve what you want. look at below links which may help you.

http://support.microsoft.com/kb/321686

http://www.eggheadcafe.com/community/aspnet/13/10018475/how-can-i-import-data-fro.aspx
0
 
PanosAuthor Commented:
OK i got it.
Thank you.
0
 
PanosAuthor Commented:
Thank you all
regards
panos
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.