Photo Gallery Member List Search Calendars FAQ Ticket List Log Out


Importing from excel to sql server

  		Logged in as: Guest
arrSession:exec spGetSession 2,3,3154
Active Users: There are 0 members and 0 guests.
Users viewing this topic: none
 

 

  
 
  Printable Version
All Forums >> [Scripting] >> ASP >> Importing from excel to sql server
  Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks! 		Page: [1]
Login
Message << Older Topic   Newer Topic >>
Importing from excel to sql server - 5/29/2005 10:20:11 PM   
  renita

 

Posts: 1
Score: 0
Joined: 5/29/2005
From: South Africa
Status: offline 		Hi all

My problem is I need to import a work sheet called Raw_Data in an Excel work Book called Reports to Microsoft SQL Server

The table has been created the table name is Stats


Have problems with the query to insert the data from the excel spreadsheet to the Table...

any help will be greatly appreciated...

If anyone as some useful code examples plz share



This is the query: I've tested in query analyser and I get an Error

INSERT INTO EntriqReports1 SELECT * FROM [Raw_Data$] IN 'c:\SuperSportReports.mdb' 'Excel 8.0;'


the error reads... Incorrect syntax near the keyword 'IN'.

_____________________________

Renita
 
 
Post #: 1
 
Re: Importing from excel to sql server - 5/30/2005 4:43:41 AM   
  VBS

 

Posts: 110
Score: 0
Joined: 3/2/2005
From: Lebanon
Status: offline 		Dear renita,
Try this site, it might help you:

http://www.w3schools.com/sql/

Best Regards
Firas S Assaad

(in reply to renita)
 
 
Post #: 2
 
 
 
 

If you found our site useful please link to us <a href="http://www.visualbasicscript.com">VisualBasicScript.com</a>.
All Forums >> [Scripting] >> ASP >> Importing from excel to sql server Page: [1]
Jump to:





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts




Forum Software © ASPPlayground.NET Advanced Edition 2.5.5 ANSI