Results 1 to 4 of 4

Thread: Import Large Textfiles (Delimited) To Microsoft SQL/MySql Server

  1. Jun 27th, 2011, 09:04 PM #1
    anamada
    anamada is offline

    Thread Starter
    Lively Member anamada's Avatar
    Join Date
    Jun 2011
    Location
    Philippines, Makati
    Posts
    107

    Exclamation Import Large Textfiles (Delimited) To Microsoft SQL/MySql Server

    Good Day!

    Is is possible to import or migrate .txt files to my database? Im using VB 2010 Express. Im just a newbie in Visual Basic and I need to import a text file into my system. Please post sample codes or process here. Feel free to ask questions. I dont know what to put here. Thanks!
    Reply With Quote Reply With Quote
  2. Jun 28th, 2011, 12:25 AM #2
    Doogle
    Doogle is offline
    PowerPoster
    Join Date
    Jul 2006
    Location
    Maldon, Essex. UK
    Posts
    6,334

    Re: Import Large Textfiles (Delimited) To Microsoft SQL/MySql Server

    You're in the wrong Forum. (This is for VB6 - Legacy Visual Basic - as opposed to the .Net versions) I've notified a Moderator and asked if they would move this to the appropriate place.

    Meanwhile, you may find this link http://blog.stevienova.com/2008/01/1...l-sqlbulkcopy/ useful.
    Reply With Quote Reply With Quote
  3. Jun 28th, 2011, 01:01 AM #3
    anamada
    anamada is offline

    Thread Starter
    Lively Member anamada's Avatar
    Join Date
    Jun 2011
    Location
    Philippines, Makati
    Posts
    107

    Re: Import Large Textfiles (Delimited) To Microsoft SQL/MySql Server

    Thank you Mr Doodle! Sorry ! My bad
    Reply With Quote Reply With Quote
  4. Jun 28th, 2011, 01:05 AM #4
    gep13
    gep13 is offline
    PowerPoster gep13's Avatar
    Join Date
    Nov 2004
    Location
    The Granite City
    Posts
    21,963

    Re: Import Large Textfiles (Delimited) To Microsoft SQL/MySql Server

    Moved to VB.Net Forum.

    Thanks for the report Doogle

    Gary
    Remember to mark your thread as resolved. Remember to rate posts that help. Hitchhiker's Guide to Getting Help at VB Forums.

    ASP.NET Tutorials (updated Feb 1st 2009) ASP.NET FAQs (updated July 17th 2011)

    Free Stuff: WebsiteSpark|DreamSpark|BizSpark|eBooks
    Learning Resources: MSDN|LearnVisualStudio|TrainingSpot|ScottGu's Blog|ASP.Net Starter Kits|Regex|RegExLib
    Useful Tools: XPath Builder|UltraMon|RegExBuddy|CopySourceAsHtml|TracExplorer|SQLyog|Chart Controls for .Net|SharePoint Designer|CodeRush Express
    Coding Links: XPath|ConnectionStrings|VB and MySQL|MySQL Connector.Net|My.Settings
    ADO.Net: MSDN Reference|Introduction|Using Access|Always use Parameters|Save and Retrieve Data - jm|An Explanation - jm
    Code Bank Submissions: Code Snippets|Profile Provider|Serialization: C# VB|Restricted Menu|Compressed HttpWebRequest|Enumerate and Add Internet Explorer Favourites: VB C#|C# Tabbed Web Browser|Enhanced Tabbed Web Browser: VB C#

    My Blog - View my MCP Certifications
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width