How to add mass data in database?

Discussion in 'Databases' started by Stefan, Nov 15, 2006.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. Hello,
    I am new in using MS SQL2005, and i have a lot of data to input into it.
    I know that Mysql supports that, but don't know how to do it with ms sql.
    Data is in xsl/csv format.
    Thank you in advance for help!
     
  2. I found this online tool,

    Click here

    You can try it out with thier trial version.

    Also if necessary you could purchase the developer version of SQL Management Studio,which wouldn't cost you much.

    Vikram

    DiscountASP.NET
    www.DiscountASP.NET
     
  3. I have Express edition which doesn't support that function.
    Any free solution?
     
  4. I don't know about the xsl part... but for csv data you could use a BULK INSERT. Just an ordinary T-SQL statement so it can be done with the express version of SQL Server Management Studio or from inside Visual Studio.

    Example -

     
  5. Thank you all for advices, i will try them and post results later.

    In meantime i am having problem inputting html script tags in nchar field. Please tell
    me how should i format that field if i want to add this type of code like a data:
    <script type='text/javascript' ............'></script>
    I think i tried text but it didn't work.
     
  6. How about varchar?Whats the problem you are facing?

    Vikram

    DiscountASP.NET
    www.DiscountASP.NET
     
  7. Well when i try to input new data via form programmed in vb, i get error message, and the problematic data is exactly that one with script tags... i've tried everything but i will end up by deleting tags , and adding them later as a label...
     
  8. Whats the error exactly?

    If its something like

    "A potentially dangerous Request.Form was detected...."

    Disable Page Validation:


    <%@ Page validateRequest="false" %> for that particluar page
    or
    <configuration>
    <system.web>
    <pages validateRequest="false" />
    </system.web>
    </configuration>


    for all pages

    Vikram

    DiscountASP.NET
    www.DiscountASP.NET
     
  9. Yes, that's it!
    And your advice helped me ....
    Thank you again!
     
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page