Help us import a 2GB CSV file into SQL server and export certain columns of data

Nice to meet you on freelancer. This sounds like a very simple project, the only problem is the file size is big. We can do below steps: * If this is a one-time query. step#1, we use a StreamReader object to read the file line by line in C# language, if we use python language, we can call open function in "r" (read mode). step#2, we need call readlines method, don't read entire file into memory. step#3, we split the line by "," to get columns, and check column C and column H, if it meet filter condition, save it into another list. step#4, save the list. * If you want to search the database many times, we then need to import to sql server or mysql database. You mentioned SQL Server, that's OK, we use SQL Server. step#1, we create a database and a table in the database, create the table accordingly to the csv columns. step#2, we the import the data into sql server database with [login to view URL] (if we use C#), I don't know how to import to sql server with python yet, most time I use mysql and python together, we can use [login to view URL] and sqlalchemy. step#3, write sql queries according to your filters. We can run these sql in sql manage tool (SQL Server Management Studio for SQL Server; MySQL Workbench for mysql), then export data into other place you want (CSV or JSON?) - we can also write this in code to run the query to get data directly. We can talk! Thank you.

i am a lead .NET software engineer and responsible for creating a web and desktop applications using different languages and technologies if u r interested just send me a message thank you and good luck

I will provide you with an executable that will browse csv file(10m+ rows) and based upon specific criteria (C is a number between 10-40, and where column H is a number between 20-200.) it will copy rows to sql server table. 1- How many columns are there in CSV ? 2- It may take time in execution,but process will be completed Looking forward to have a chat with you to discuss further.

Hi, I'm an expert Windows database application developer with experience in developing data import applications for SQL databases, incl MS-SQL Server. Per your requirements, I am bidding to develop a standalone Windows desktop application that will allow you to : 1. Import the CSV data to your SQL Server databse 2. Present an user interface to filter / query the data, and to Export the filtered (or all) data to CSV file I estimate the delivery time for the first working version of the application to be 5 days, or less. Good quality work done. I will also be available on the long term should you need additional modifications or support. Thanks for considering my bid. Best wishes, Steve ~ Larry Anselof Technology Solutions - Providing a quality and reliable freelance software development service since 2004 ~

Hello I'm Abu Gosia I m quite well experienced in these jobs I'm interesting your project very well I'm good in Website Design, Yii2, PHP, Laravel, Codeigneter, Wordpress, Open Cart, C#, .Net, MVC, Angular.js, ASP.NET. Let's go ahead with me. Thanks

Hello, I have 15+ years of experience in C#, Vb.Net, MSSQL, MySQL, SQLite, Visual FoxPro 9. I can import your CSV data into the SQL server and I can export it as per your requirement. can we discuss your requirement? thanks Kalpesh

Hello my dear, I saw your screenshot which was about Excel DB, So I can make a Java app which doing all you need, Inserting and also exporting as per as you need. it will be nice :D Thanks regards Bryar

Hi, As I understand you have large tab delimited CSV file with around 2 GB size. I have queries, would appreciate your response on the same 1) Is there any specific reason you would like to import this entire data into SQL Server. 2) Are you ok with the option of getting the results while the data remains in CSV file 3) Is it correct to assume that final output also has to be in tab delimited CSV file. Looking forward to your response. Thanks

Hello Sir, As you are looking for .NET developer to work on your import a 2GB CSV file into SQL server and export certain columns of data project, I am please to offer my services for same. I have huge experience in building complex enterprise level and multi tenant base web application using asp.net mvc, c#, sql server, Javascript, Bootstrap, EF, LINQ, EFCore, .NetCore, Angular, Typescript, Git & jQuery. Kindly let us know your suitable time for further discussion about this project, in meantime kindly review below clients feedback.. Looking forward to work together... Thanks, Akshay PS : Here's what some of our existing clients have said: -- “Akshay is a perfect developer and a very good man. This was our first task, and we started to code 3 more projects together after this task. I recommend to work with him to everybody” -- “Very professional work delivered ontime, with promise for future support. I'm delighted working Akshay” -- “Akshay is an extraordinary freelancer. He is knowledgeable and very professional. He completed the project within the budget and on time despite multiple challenges. We had the initiative to continue looking for solutions until the team was completely satisfied. Very recommended” -- “Very punctual, friendly and understanding developer.” -- “Good to work with Akshay and would recommend for the future, expert in front end development, good communication"

Hi. I have written many database projects including SQL Server. Ready to write your project. Will complete within 2 days

Hello. I can do it. It is impossible with traditional way, but I have the BEST way not depending on the capacity. Please contact me. thanks. Best Regards. From Alexandra.

Dear Sir, I am Ali having 6+ years of experience in software development. My developed apps are fast, secure, easy to use and install. I am dedicated freelancer and can be available any time and can deliver your project before deadline. You can see my profile and portfolio as reference. I am 100% sure i can solve your problem. Best Regards, Ali

Hello, i'm an expert IT with more 15 years of experience in IT industry . i'm certified Cisco networking professional 300-100 and 300-115 and Linux professional lpi 101, 102 and RHCSA and VCP 4, 5,5.5 and Data Center and MSCA/MSCE ranging from 2003 to 2012 .i'm ready to help you asap

Dear Sir, I am expert in database Management System , I can complete your task within hours, lets have some chat to knot the deal, I have already completed same projects with good reviews. Regards, Aiksol.

Hello I believe I can quickly help you import your CSV file data. I am a Danish software developer, living abroad. I have many years of experience developing .Net applications and MSSQL databases. If you give me access to a database server close to you, then I can import the data with the least network latency. After that I can also help develop export queries, if needed. You are welcome to initiate a private chat to know more.

Hello I can complete this job within 24 hours. I am ready to start now. Thanks & Regards, Everest Technology

Hi there, I see you need to load a CSV file with 2GB of data and then import them all to SQL Server. I've got full sense of what your goal in this project. I'm familiar with both MySQL and SQL Server. Working with C# or Python is no problem to me. But I prefer to work with Python because fast implementation. We could discuss more in our chat. Hope to see your response. Best regards, Nam

Ready to get the query data as you described from the csv file, there is a better option than loading to sql server then queuing the required records. I can connect over Teamviewer to your machine or you can attach a link to download the csv file if possible. I will send you the required output data directly, optional with a tool to let you get the data whenever you want message me, let’s set how you want to work and get the job done.

Hello, my name is Salvatore and I am a programmer with 10 years of experience. I mainly deal with the analysis and development of management software on demand with related web applications and mobile apps. I work with the following languages: vb.net, c #, .net core, asp.net MVC, HTML5, css, Javascript, Java and Swift. I know both Sql server and mySql databases very well. I am new to this platform and would like to start working. I can develop a very simple program that reads the CSV file and imports directly into the Database.

Completed numerous similar projects in the past and always impressed the clients with my excellent solutions.  Expert Data Analyst having in depth knowledge in Databases. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills.  And I have been consistently rated as excellent by all the employers. Looking forward to hear from you soon. Have a great day. Thank you.

Hi I have experience about that. I can do it. Regards Eric.....