Homework

Homework Questions? Ask a Tutor for Answers ASAP

Ask an Expert,
Get an Answer ASAP!

I need a script to parse a .csv file using MS Visual Studio…

Customer Question
Hi!I need a script to...
Hi!I need a script to parse a .csv file using MS Visual Studio to prepare it to be transformed and loaded into a data warehouse.
I already have some data in MS Access tables.Will give you more details if interested.Thanks.
Submitted: 11 months ago.Category: Homework
Show More
Show Less
Ask Your Own Homework Question
Answered in 10 hours by:
9/10/2017
Tutor: George Sibiya, Computer Hardware Engineer replied 11 months ago
George Sibiya
George Sibiya, Computer Hardware Engineer
Category: Homework
Satisfied Customers: 367
Experience: PhD in Computer Science
Verified

Hi,

Welcome to JustAnswer and thank you for utilising our services

In what programming language should the script be written?

Regards,

G

Ask Your Own Homework Question
Customer reply replied 11 months ago
Hi, George!
It needs to be in SQL for MS SQL Server Management Studio. I was able to convert the files to .csv format and imported them successfully in MS SQL Server. Had trouble importing them before but got it all fixed in the interim.
Please advise.
Thanks.
Tutor: George Sibiya, Computer Hardware Engineer replied 11 months ago

Ok thanks for the info. I am reviewing it

Ask Your Own Homework Question
Tutor: George Sibiya, Computer Hardware Engineer replied 11 months ago

Ok so there is a manual process to export access db to to sql server but I understand you want to automate that. I am working on it and will communicate after about 6 six hour as I am about to fly

Ask Your Own Homework Question
Customer reply replied 11 months ago
OK. That works. Here is what I need in the script.
Three new tables need to be created – tblTeenFiction, tblLibraryID and tblNewspapers. Then the tblCustomers needed to be joined to the table tblLibraryID so more data can be added.
The tblTeenFiction shold have the same fields as tblBooks, but the column Format should reflect Teen Fiction.
The tblLibraryID should have the fields CustomerID, FirstName and LastName fields plus LibraryID.
The tblNewspapers should have the same fields as tblBooks, but the format column should say Newspaper.
Finally, the LibraryID field needs to be inserted in the tblCustomers.Hope this helps. I was able to create the .csv files and import them successfully to SQL server (yes, I do work on my homework). Had trouble before but fixed it.6 hours if fine. Charge? I assume it's upon receipt. I know enough to know if the script is right.Feedback, please.
Thanks.
Customer reply replied 11 months ago
Don't have time for phone calls, but thanks for the offer.
Was this answer helpful?

How JustAnswer works

step-image
Describe your issueThe assistant will guide you
step-image
Chat 1:1 with a tutorLicensed Experts are available 24/7
step-image
100% satisfaction guaranteeGet all the answers you need
Ask Scott Your Own Question
Scott
Scott
Scott, MIT Graduate
Category: Homework
Satisfied Customers: 3,040
3,040 Satisfied Customers
Experience: MIT Graduate (Math, Programming, Science, and Music)

Scott is online now

A new question is answered every 9 seconds

How JustAnswer works:

  • Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction GuaranteeRate the answer you receive.

JustAnswer in the News:

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

What Customers are Saying:

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

EstherWoodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

RobinElkton, Maryland

He answered my question promptly and gave me accurate, detailed information. If all of your experts are half as good, you have a great thing going here.

DianeDallas, TX

< Previous | Next >

Meet the Experts:

LogicPro

LogicPro

Engineer

5,894 satisfied customers

Expert in Java C++ C C# VB Javascript Design SQL HTML

Manal Elkhoshkhany

Manal Elkhoshkhany

Tutor

4,556 satisfied customers

More than 5000 online tutoring sessions.

Linda_us

Linda_us

Finance, Accounts & Homework Tutor

3,138 satisfied customers

Post Graduate Diploma in Management (MBA)

Chris M.

Chris M.

M.S.W. Social Work

2,699 satisfied customers

Master's Degree, strong math and writing skills, experience in one-on-one tutoring (college English)

F. Naz

F. Naz

Chartered Accountant

2,194 satisfied customers

Experience with chartered accountancy

Bizhelp

Bizhelp

CPA

1,887 satisfied customers

Bachelors Degree and CPA with Accounting work experience

Seanna

Seanna

Tutor

1,781 satisfied customers

3,000+ satisfied customers, all topics, A+ work

< Previous | Next >

Related Homework Questions
I need a script to parse several .csv files using Microsoft
Hi!I need a script to parse several .csv files using Microsoft SQL Server Management Studio to prepare them to be transformed and loaded into a data warehouse. I have the MS Access tables, converted t… read more
George Sibiya
George Sibiya
Computer Hardware Engineer
367 satisfied customers
=====For LogicPro Only======== Please modify and add the
=====For LogicPro Only======== Please modify and add the following to the last script you created: 1. Have the script to stop when there is any error for example mysql database connection fail error a… read more
LogicPro
LogicPro
Engineer
Bachelor of Technology
5,894 satisfied customers
Synopsis Management and users make important decisions based
Synopsis Management and users make important decisions based on system outputs. Outputs present information to system users. Outputs, the most visible component of a working information system, are th… read more
Mr. Wilson
Mr. Wilson
Teacher
Master\u0027s Degree
200 satisfied customers
Pro: I have the work that has been completed on here already
For Logic Pro: I have the work that has been completed on here already (there is a lot of it done) there needs to be a customer tab added (which is the focus for this question). Let me know how to upl… read more
LogicPro
LogicPro
Engineer
Bachelor of Technology
5,894 satisfied customers
An organization has several operational systems: Customer Relationship
An organization has several operational systems: Customer Relationship Management (CRM) for marketing and sales, Enterprise Resource Planning (ERP), and Supply Chain Management (SCM). They also have e… read more
Mr. Wilson
Mr. Wilson
Teacher
Master\u0027s Degree
200 satisfied customers
This is the same assignment I am having issues with, I can
Your first task in developing the application for tracking contributors is to load a list of the people who are helping the cause. Design and develop a linked list, implemented as a stack, to track al… read more
LogicPro
LogicPro
Engineer
Bachelor of Technology
5,894 satisfied customers
Hi! I need the following completed by 8pm EDT on 11/16/14.
Hi! I need the following completed by 8pm EDT on 11/16/14. Please note that I need ALL parts completed - A, B, AND C ("...an explanation of the work done and how it is possible to arrive at the provid… read more
ATLProg
ATLProg
Sr Software Engineer
Master\u0027s Degree
46 satisfied customers
C#. Create an application where user can enter phone book
Hi, can you please help me with this questions. C#. Create an application in which a user can enter a phone book entry, including the following elements: 1. First Name, Last Name, Phone Number, email … read more
TheDoctor
TheDoctor
Software Engineer
Master\u0027s Degree
9 satisfied customers
**TheDoctor** I need help with a web application. I thought
**TheDoctor** I need help with a web application. I thought it would be a simple matter to alter the code that I already have that inputs, updates, and deletes using ASP.NET C#. After four attempts ju… read more
TheDoctor
TheDoctor
Software Engineer
Master\u0027s Degree
9 satisfied customers
Hey Doc, my question goes back from one of my questions that
Hey Doc, my question goes back from one of my questions that you had answered, before, but needs to be revised. Here are the instructions, i have also attached the access database : ASP.NET Web Applic… read more
TheDoctor
TheDoctor
Software Engineer
Master\u0027s Degree
9 satisfied customers
*For LogicPro Only* MUST be written in C# XXXXX Visual C# XXXXX
*For LogicPro Only* MUST be written in C# XXXXX Visual C# XXXXX Express or Visual Studios 2010 Professional OR Newer. Extended Checkbook Organizer – Batch Mode Expand the Checkbook Organizer from Assi… read more
LogicPro
LogicPro
Engineer
Bachelor of Technology
5,894 satisfied customers
Have been out of town until just today and am unable to complete
Have been out of town until just today and am unable to complete this second-to-last assignment in time. Assistance prior to 11XXXXXwould be appreciated. Thank you. Step 1: Given a file of data, read … read more
Raj
Raj
SAP ABAP Consultant
Master\u0027s Degree
27 satisfied customers
There is a firm requirement to code the following solution
There is a firm requirement to code the following solution in Java specifically. Simply, I need to generate a new Microsoft Word document from a template. The new document include the template content… read more
Mr. Wilson
Mr. Wilson
Teacher
Master\u0027s Degree
200 satisfied customers
large data set and I need to do the following in R
Attachment: 2013-08-20_225351_new_data_-_august_16_2013.xlsx I have a large data set and I need to do the following in R: 1. To do: Identify rows in the data that have the following error. For some ch… read more
R.R. Jha
R.R. Jha
Bachelor\u0027s Degree
150 satisfied customers
**For TheDoctor** I have a question for you if you can this
**For TheDoctor** I have a question for you if you can this answer me. I will send the question.… read more
TheDoctor
TheDoctor
Software Engineer
Master\u0027s Degree
9 satisfied customers
For LogicPro Only: Help using the Sort Facilities part A
For LogicPro Only: Help using the Sort Facilities part A and part B Enhancing Payroll System using MS Visual C++ 2010 Express. Here is the link for Part A & B: http://wikisend.com/download/542110/Wk 8… read more
LogicPro
LogicPro
Engineer
Bachelor of Technology
5,894 satisfied customers
I need the quadtree program to function differently than it
Attachment: 2012-12-10_042254_quadtree.zip Attachment: 2012-12-10_041959_quadtree_form.zip I need the quadtree program to function differently than it does. I have created a visual studio form that I … read more
R.R. Jha
R.R. Jha
Bachelor\u0027s Degree
150 satisfied customers
Write a library containing functions to compute the surface ...
Write a library containing functions to compute the surface area and volume of a sphere. For a sphere of radius r, these values can be calculated using: Surface Area = 4 Pi r squared (4 x Pie x r to t… read more
M. R. Mazumdar
M. R. Mazumdar
Owner
Ph.D
82 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less

Ask Your Question

x