Click here to Skip to main content
15,880,469 members
Home / Discussions / Web Development
   

Web Development

 
AnswerRe: How Much the Budget should be for a website like OLA and UBER Pin
SeeSharp214-Jul-21 10:41
SeeSharp214-Jul-21 10:41 
QuestionImport Excel sheet into Gridview and SQL Pin
Michael Hinkle18-May-21 16:41
Michael Hinkle18-May-21 16:41 
AnswerRe: Import Excel sheet into Gridview and SQL Pin
Richard MacCutchan18-May-21 21:15
mveRichard MacCutchan18-May-21 21:15 
GeneralRe: Import Excel sheet into Gridview and SQL Pin
Richard Deeming18-May-21 21:39
mveRichard Deeming18-May-21 21:39 
GeneralRe: Import Excel sheet into Gridview and SQL Pin
Richard MacCutchan18-May-21 22:01
mveRichard MacCutchan18-May-21 22:01 
GeneralRe: Import Excel sheet into Gridview and SQL Pin
Michael Hinkle19-May-21 17:27
Michael Hinkle19-May-21 17:27 
AnswerRe: Import Excel sheet into Gridview and SQL Pin
Richard Deeming18-May-21 21:42
mveRichard Deeming18-May-21 21:42 
AnswerRe: Import Excel sheet into Gridview and SQL Pin
Mycroft Holmes20-May-21 12:55
professionalMycroft Holmes20-May-21 12:55 
Assuming SQL means SQl server the why not do the clean up in SSMS. My standard method was:

Import the data manually into SQL Server. I would load the data into a new table accepting whatever garbage is in the excel file. All data should be converted to strings on the way in.

Create and empty destination table matching your final destination (this is so you can repeat the process)

Write a stored procedure that:
loops each column and cleans and formats the data as required and inserts it into the temp table.

When you are confident the process works then change the destination to the final destination table.

If this works consistently between loads you can then turns the entire process into a Job which can then be launched by your application.

This method does require reasonable T-SQL skills but would also be an excellent learning exercise.
Never underestimate the power of human stupidity -
RAH
I'm old. I know stuff - JSOP

AnswerRe: Import Excel sheet into Gridview and SQL Pin
David Mujica21-May-21 5:26
David Mujica21-May-21 5:26 
AnswerRe: Import Excel sheet into Gridview and SQL Pin
SeeSharp214-Jul-21 10:41
SeeSharp214-Jul-21 10:41 
QuestionBlazor + MVC Pin
Super Lloyd11-May-21 4:37
Super Lloyd11-May-21 4:37 
AnswerRe: Blazor + MVC Pin
Super Lloyd11-May-21 4:58
Super Lloyd11-May-21 4:58 
QuestionIntegrate 3rd party Authenticator app Pin
Super Lloyd10-May-21 13:47
Super Lloyd10-May-21 13:47 
AnswerRe: Integrate 3rd party Authenticator app Pin
Richard Deeming18-May-21 4:06
mveRichard Deeming18-May-21 4:06 
GeneralRe: Integrate 3rd party Authenticator app Pin
Super Lloyd18-May-21 16:48
Super Lloyd18-May-21 16:48 
QuestionCSS not showing on my website! HELP! Pin
Gee_Suss 9-May-21 11:27
Gee_Suss 9-May-21 11:27 
AnswerRe: CSS not showing on my website! HELP! Pin
SeanChupas11-May-21 3:04
SeanChupas11-May-21 3:04 
QuestionFiltering an array of objects based on (another object/array of objects) Pin
Pavithran R8-May-21 9:07
Pavithran R8-May-21 9:07 
AnswerRe: Filtering an array of objects based on (another object/array of objects) Pin
jsc429-May-21 22:33
professionaljsc429-May-21 22:33 
QuestionPHP7, uasort method, return new instance Pin
jkirkerx23-Apr-21 8:12
professionaljkirkerx23-Apr-21 8:12 
AnswerRe: PHP7, uasort method, return new instance [Maybe Solved] Pin
jkirkerx24-Apr-21 9:53
professionaljkirkerx24-Apr-21 9:53 
Questionsearch word in code phpstorm Pin
sookitak18-Apr-21 4:06
sookitak18-Apr-21 4:06 
AnswerRe: search word in code phpstorm Pin
SeanChupas23-Apr-21 9:16
SeanChupas23-Apr-21 9:16 
QuestionMaster Detail CRUD using blazor Pin
sanket16413-Apr-21 20:52
sanket16413-Apr-21 20:52 
SuggestionRe: Master Detail CRUD using blazor Pin
Shaun C Curtis14-Apr-21 6:37
mvaShaun C Curtis14-Apr-21 6:37 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.