I am using VBA to insert 6-column data from Excel to SQL server. The data will be firstly convert to JSON, then to DB. If the rows are less than 2600 rows, it will be inserted. Otherwise, VBA reports the data sent, but it's actually not in the DB server. The biggest column data length is about 20 characters (in DB, it's far longer with Varchar type). Is there any limitation?
The other issue is: when DB server OS changes Daylight time zone, there is one column records Date&Time, when successfully inserted, it will be one hour less. Say it's 9:00am in Excel, then it's 8:00am in SQL Server. No clue on this since OS time changes already.
The other issue is: when DB server OS changes Daylight time zone, there is one column records Date&Time, when successfully inserted, it will be one hour less. Say it's 9:00am in Excel, then it's 8:00am in SQL Server. No clue on this since OS time changes already.