|
Upload the excel file to your SQL Server, then use SQL Server Data Transformation Services (DTS) to open the file and insert the data into your table for you. It should take a few seconds at most...
-------------------------------------------
Don't walk in front of me, I may not follow;
Don't walk behind me, I may not lead;
Just bugger off and leave me alone!!
|
|
|
|
|
Thanks it works fine.
IF anyone known about BCP related to this synario,
please explain
Thanks in Advance
|
|
|
|
|
BCP only works with ASCII text files. You would have to save the contents of your spreadsheet as CSV or tab-separated files first.
|
|
|
|
|
What is Broker service in SQL server and
How to enable Broker services on MS SQL Server 2005?
Thanks
PRT
|
|
|
|
|
|
If a view is called multiple times by various applications, how does sqlserver respond? Does it execute the select statement (inside the view) only once or does it execute them per request?
|
|
|
|
|
it execute them per request.. 
If you don't mind, on what purpose that make u consider such a question? Performance?
|
|
|
|
|
Me and my friend were discussing whether to go for a view or a stored procedure, because all we needed was an inventory report kind of stuff... I just learned that we further "abstract" from a view whose inside select statement is a kind of general query with no where condition or with some minimal conditions. A stored procedure on the other hand would work faster because we are exacting data we need with more where conditions. In both the cases we are only interested in the result set.
|
|
|
|
|
Hi,
My WinForm application uses an Access 2000 file format database (using OleDbCommand with C#.NET).
I'm wondering if I should upgrade to a newer version (2003 or 2007). Can anyone tell me the advantages of usng Access 2003/2007 over 2000?
thanks,
Ron
|
|
|
|
|
I don't think there is much of a difference between 2003/2007.
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Hi, guys. I need some help with the DoCmd.OutputTo method in MS Access. I would like to export the file to a .CSV file but the only options that I have are as follows:
AcFormat can be one of these AcFormat constants.
acFormatASP
acFormatDAP
acFormatHTML
acFormatIIS
acFormatRTF
acFormatSNP
acFormatTXT
acFormatXLS
The code for DoCmd.OutputTo is as follows:
DoCmd.OutputTo acOutputTable, "tblInputFile", _
acFormatTXT, "C:\test\output.csv", True
I tried to use the acFormatTXT option to export to the .CSV file. I need the result to be a comma delimited list, but it comes out like this:
--------------------------------------------------------------
| USA | WFTE | SUPPORT | Global | GLOBAL | Facilities & Real | 4 | 57AU |
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| USA | WFTE | SUPPORT | Global | GLOBAL | General Supply | 0 | 57AU |
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| USA | WFTE | SUPPORT | Global | GLOBAL | Marketing | 0 | 57AU |
-----------------------------------------------------------------------------------------------------------
-- modified at 13:13 Monday 29th October, 2007
|
|
|
|
|
hi All
i have some DTS that run at night. they were running for year now, but Sudenly the give this Errors when i run them.
Select permission denied on object 'sysobjects',database
'Tshwane_valuations',owner 'dbo'.(
Microsoft Ole DB Provider for SQL
(0):Started-OITPS_ALL_Create_Temp)
What Could be a Problem.
Thanks
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sudden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
You do not have permission on this system table.
If, you have database team then contact them, they will definately solve your problem..
|
|
|
|
|
Thanks man , it helped me a lot
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sudden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
System.ArgumentException: Redirect URI cannot contain newline characters.
I'm getting this error while selecting one of the record from a datagrid using a Request.String and display the records value into another page.
Pls help me in this regard.
|
|
|
|
|
|
Good Day,
I have installed MS SQL 2005 Express on my Desktop and Laptop machine. Most of the development are being done in my desktop. Sometimes, My bro uses the desktop and I'm using the laptop to do development. (C#)
How can I retrieve some data from the SQL Server installed in my Desktop using my LAPTOP? What are the settings I need to fix inside the SQL Server Configuration Manager. (TCP/IP ?)
Please advice, Thanks.
Ian Uy
|
|
|
|
|
Ian Uy wrote: What are the settings I need to fix inside the SQL Server Configuration Manager. (TCP/IP ?)
That would seem to be sensible. Remember to block the port that SQL Server is using on your external firewall.
|
|
|
|
|
Thanks for the reply.
What are the exact settings that I need to adjust in my DESKTOP to allow in-bound connections from my laptop?
|
|
|
|
|
Ian Uy wrote: What are the exact settings that I need to adjust in my DESKTOP to allow in-bound connections from my laptop?
Turn TCP/IP on in SQL Server. Ensure that the firewall permits the port (usually 1433) within your network (but not outwith your network)
|
|
|
|
|
|
Good Day,
I have read the article and have executed every instruction properly.
But I am getting a weird error, I have search for the answer but have failed.
This is the error:
<br />
A connection was successfully established with the server, but then an error occurred during the login process. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.) (Microsoft SQL Server, Error: 10054)<br />
|
|
|
|
|
Hi,
This is rajendran,working as a web developer.I have doubt in SQL server 2005 like How to get the alias name for field name using Cursor..Plz reply me..
Thanks
Ra jendran
|
|
|
|
|
Raa ju wrote: Hi,
This is rajendran,working as a web developer.I have doubt in SQL server 2005 like How to get the alias name for field name using Cursor..Plz reply me..
Thanks
I dont know how it would help by posting the question over and over again... you need to be patient. If you havent received any answers so far, it is possible that others have either not seen your post yet or you might have to provide more information for them to be able to help you...
|
|
|
|
|
ChandraRam wrote: dont know how it would help by posting the question over and over again...
It doesn't and it makes people less likely to reply.
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
