Does the case matter?

1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User

Welcome to IWETHEY!

Post #403,887 by Another Scott 8/7/15 11:56:05 AM Reply	Does the case matter? In some of the lines you have .select() and in some you have .Select() Does it matter? If not, maybe this thread will help - http://stackoverflow.com/questions/19801598/excel-vba-date-formats Adding some error checking might tell you what's going on. Good luck. Cheers, Scott.
Post #403,888 by lincoln 8/7/15 1:23:04 PM Reply	just for grins I made a copy of the table, changing the two date columns to be NVARCAR (10). Loaded the copy with test data and reran the program. No effect. Satan (impatiently) to Newcomer: The trouble with you Chicago people is, that you think you are the best people down here; whereas you are merely the most numerous. - - - Mark Twain, "Pudd'nhead Wilson's New Calendar" 1897

Trying to format a Excel column as Date from VB.Net - (lincoln) - (10) - Aug. 7, 2015, 10:38:29 AM EDT

Does the case matter? - (Another Scott) - (1) - Aug. 7, 2015, 11:56:05 AM EDT

just for grins - (lincoln) - Aug. 7, 2015, 01:23:04 PM EDT

This worked, but it takes longer - (lincoln) - Aug. 7, 2015, 04:38:37 PM EDT

How do you export/import? - (scoenye) - (1) - Aug. 7, 2015, 10:02:14 PM EDT

The batch process has a program that uses a SQL Bulk Insert - (lincoln) - Aug. 8, 2015, 10:47:55 PM EDT

Well, they won't let me use a varchar - (lincoln) - (4) - Aug. 11, 2015, 01:26:11 PM EDT

The only way I can reproduce is if the cell contains a string - (scoenye) - (3) - Aug. 11, 2015, 04:05:01 PM EDT

StartDate = "01/01/1900" -NT - (lincoln) - (2) - Aug. 11, 2015, 08:15:33 PM EDT

The epoch start date is 1900-jan-00 - (scoenye) - (1) - Aug. 11, 2015, 10:35:00 PM EDT

That's why I used 1/1/1900 - (lincoln) - Aug. 12, 2015, 01:28:48 PM EDT

The namespace is ... large. And a dictionary attack against a ... large namespace is ... large and then some.
72 ms