Import complicated Text file into SQL Database

Completado Publicado hace 5 años Pagado a la entrega
Completado Pagado a la entrega

Hello. We potentially will be receiving a file in this format each day that I need to import into an SQL database. The formatting of the text file data is unfamiliar to me and I am currently unable to get it into SQL.

The database can be created with whichever fields are necessary to receive the data (I assume columns should be Code Description Blocks Lots DetailLevel Arbs NoBlocks NoLots Sub_Comments Sub_Close_Flag Close_Flags Close_Comments).

Preferrably I'm looking for an SQL Script I can run each day to import this data file without going through a bunch of DTS Import wizard steps.

Please take a look at the attached file before bidding.

Thanks!

Programación de bases de datos Servidor de Microsoft SQL SQL

Nº del proyecto: #18502811

Sobre el proyecto

34 propuestas Proyecto remoto Activo hace 5 años

Adjudicado a:

sumon355

Hello, As an expert in MS SQL Server, i am very much interested to do this task. I saw your attached file, in fact i would prefer to provide you an application for this purpose. You will be able to use in in windows t Más

$90 USD en 2 días
(239 comentarios)
7.6

34 freelancers están ofertando un promedio de $138 por este trabajo

tranngocanh1702

Hi, I am Anna with more than 7 years experience in web and cross-platform app development including Hybrid, PHP, Laravel framework, Slim, CodeIgniter, MySQL, PostgreSQL, HTML, CSS, Javascript, jQuery, Vuejs, Ajax, Más

$150 USD en 3 días
(14 comentarios)
5.8
fanninson45

INTRODUCTION I can see you are interested in importing file into your back-end database. I have also studied your subdivision txt attachment. I have done so many database administration of this website before and I Más

$150 USD en 3 días
(23 comentarios)
6.0
hunmin888

Hi employer I have a good experience in sql I am a dB expert So I wish you will work with me for this project Please reply me kindly Thanks

$172 USD en 1 día
(11 comentarios)
5.4
schoudhary1553

Hello, Hope you are doing well. I can help with you in your project Import complicated Text file into SQL Database. I can assure you the quality job. I have good experience in Database Programming, Microsoft S Más

$180 USD en 3 días
(10 comentarios)
5.5
uhjk

Hello, it seems it's csv file with tab delimited. I can create php script which insert this data to your mysql database. I can deliver you php script in 3-4 hours at most. Then, you can create cronjob for it to run eve Más

$100 USD en 1 día
(21 comentarios)
4.8
xinglong717

Hi. I'm Enkhbayar B in Japan. I have read your description in detail and have interests in your project. I have many experiences that have ever done what is similar to your project. As a solution, I have a good Más

$150 USD en 3 días
(9 comentarios)
4.1
brianconey

hi there I have read your description i it is possible on pyton or c# I cando all as your reqruiement thanks

$155 USD en 3 días
(4 comentarios)
4.1
dhruvgupta1992

Hi, Greeting for the day. I will give you the automated script so you need to do it everyday. Lets discuss in details. I can deliver you this project with the best cost in the mention time or less. Let's Discu Más

$122 USD en 2 días
(6 comentarios)
3.7
fleedsteed

Hello, sir. It's a pleasure to meet you. I read your job description very carefully and looked at your attached doc I understand what you want. I can implement what you want using python Python provides powerful Más

$200 USD en 3 días
(1 comentario)
3.7
alejandrobravo1

Hello I have reviewed the file and I can help you to load this to SQL server. My suggested approach is a powerhsell script that you can run that can load the information to SQL server. I have my own environment s Más

$250 USD en 5 días
(5 comentarios)
3.8
mikenru1

Hi! Have done such task before. Recording data from xls to database. Let's discuss your needs in chat

$100 USD en 5 días
(13 comentarios)
3.8
IntrinsecoTImx

Hi Colleague! We are SQL experts with 15+ years of experience. We can easily help you create a sp to import this file using a Bulk Insert process, i’ve seen the file and this would be easy to import to MSSQL. We wil Más

$220 USD en 1 día
(2 comentarios)
3.8
shailikhatri

I am an experienced Web and Software Developer, and I am very interested in your job post. I have an excellent experience in MVC,.Net Core, ASP.NET, C#, Linq, Entity Framework, MySQL, MSSQL, REST API, JSON, HTML5, A Más

$222 USD en 5 días
(2 comentarios)
3.8
fadata

Hi I can write a script or an application for you to import your text file to database. I prefer application. Lets talk about the details Regards Fatih

$222 USD en 3 días
(4 comentarios)
3.6
Astalavist4

Hi, I can help you with this project. I will write you a small c# script that will connect to the database and import this file format into the table. You were right about the table columns. I can complete Más

$88 USD en 3 días
(4 comentarios)
3.3
ozzy72

Hi, I am PHP/MySQL coder and would like to generate the script for you. The file you provided is a simple CSV file. Usually CSV is seperated by comma, but in your case it's space(s). This shouldn't be a problem. I ca Más

$77 USD en 3 días
(1 comentario)
3.3
nidhi1509

Hi, I have seen the file that you have attached in the requirement and can understand the format mentioned. I am sure that I would be able to complete this project as required as I have worked on similar requirements b Más

$83 USD en 3 días
(6 comentarios)
3.2
leemilun

Hi, Sir. Nice to meet you. I have seen your attached file. I have rich SQL experience. I can do perfectly. We can discuss more detail on Chatting Room. Thank you.

$155 USD en 3 días
(2 comentarios)
3.1
rlo56467a9097547

Hello there I can do a php script to automatic run each day and import data Contac me !!

$83 USD en 1 día
(4 comentarios)
2.7
pdxbi

This looks fairly straight forward. Assuming you have SA (System administration) privileges on SQL I can do this one of two ways depending on your preference: 1. Create a SQL Server Integration Package, Deploy and s Más

$155 USD en 2 días
(1 comentario)
2.4