Click here to Skip to main content
15,906,558 members
Home / Discussions / ASP.NET
   

ASP.NET

 
AnswerRe: SELECT DISTINCT Pin
Member 1562749519-May-22 11:11
Member 1562749519-May-22 11:11 
GeneralRe: SELECT DISTINCT Pin
Richard Deeming19-May-22 21:42
mveRichard Deeming19-May-22 21:42 
GeneralRe: SELECT DISTINCT Pin
kjell.ek20-May-22 2:58
kjell.ek20-May-22 2:58 
GeneralRe: SELECT DISTINCT Pin
Alaren23-Jun-22 5:23
Alaren23-Jun-22 5:23 
QuestionMilliseconds from excel Pin
kjell.ek16-May-22 10:10
kjell.ek16-May-22 10:10 
AnswerRe: Milliseconds from excel Pin
Richard Deeming16-May-22 21:35
mveRichard Deeming16-May-22 21:35 
GeneralRe: Milliseconds from excel Pin
kjell.ek16-May-22 23:15
kjell.ek16-May-22 23:15 
AnswerRe: Milliseconds from excel Pin
Raj Kumar7918-Oct-22 5:12
Raj Kumar7918-Oct-22 5:12 
Format 109 is like "Jun 17 2012 2:00:29:147PM", so obviously [Start Date] is varchar already before the convert.

I suspect that that problem is that Excel thinks that this is a datetime value, and that's why the milliseconds are lost in transport. Excel is not really the best venue for strict data-typing, but rather the drivers makes some guesswork. You could try to format the column as text, but I am not sure it would help.

I never use OPENROWSET/OPENDATASOURCE to read Excel files myself. For one-offs I save the file as a CSV and import it with BCP. For imports on regular basis, I would write a client program for the task. Many people would go for a soluton with Integration Services.
QuestionASP.NET Gridview load data Pin
Herman<T>.Instance28-Apr-22 3:16
Herman<T>.Instance28-Apr-22 3:16 
AnswerRe: ASP.NET Gridview load data Pin
Richard Deeming28-Apr-22 4:40
mveRichard Deeming28-Apr-22 4:40 
GeneralRe: ASP.NET Gridview load data Pin
Herman<T>.Instance2-May-22 0:47
Herman<T>.Instance2-May-22 0:47 
GeneralRe: ASP.NET Gridview load data PinPopular
Dave Kreskowiak2-May-22 2:12
mveDave Kreskowiak2-May-22 2:12 
GeneralRe: ASP.NET Gridview load data Pin
Herman<T>.Instance2-May-22 3:23
Herman<T>.Instance2-May-22 3:23 
GeneralRe: ASP.NET Gridview load data Pin
Herman<T>.Instance3-May-22 4:46
Herman<T>.Instance3-May-22 4:46 
GeneralRe: ASP.NET Gridview load data Pin
Richard Deeming3-May-22 5:31
mveRichard Deeming3-May-22 5:31 
GeneralRe: ASP.NET Gridview load data Pin
Herman<T>.Instance3-May-22 5:38
Herman<T>.Instance3-May-22 5:38 
GeneralRe: ASP.NET Gridview load data Pin
Richard Deeming3-May-22 5:48
mveRichard Deeming3-May-22 5:48 
GeneralRe: ASP.NET Gridview load data Pin
Herman<T>.Instance3-May-22 7:12
Herman<T>.Instance3-May-22 7:12 
GeneralRe: ASP.NET Gridview load data Pin
Richard Deeming3-May-22 21:38
mveRichard Deeming3-May-22 21:38 
GeneralRe: ASP.NET Gridview load data Pin
Herman<T>.Instance3-May-22 22:03
Herman<T>.Instance3-May-22 22:03 
QuestionSend Email using Classic ASP Pin
Ram Teckchandani11-Apr-22 17:28
Ram Teckchandani11-Apr-22 17:28 
AnswerRe: Send Email using Classic ASP Pin
Richard MacCutchan11-Apr-22 22:00
mveRichard MacCutchan11-Apr-22 22:00 
QuestionMVC 5 Prevent Users From Going Back After Logging In or Out Using Identity Framework Pin
Steven Petersen3-Apr-22 9:11
Steven Petersen3-Apr-22 9:11 
AnswerRe: MVC 5 Prevent Users From Going Back After Logging In or Out Using Identity Framework Pin
Richard Deeming3-Apr-22 21:24
mveRichard Deeming3-Apr-22 21:24 
QuestionA question about CreatedAtAction() method Pin
Alex Dunlop23-Mar-22 21:44
Alex Dunlop23-Mar-22 21:44 

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.