New answers tagged excel
0
Microsoft SQL Server Management Studio launched the 32-bit version of the import wizard.
I found the 64-bit version of the import wizard already installed as a standalone App. Launching that standalone App worked.
0
Follow these steps:
Go here, download Microsoft Access Database Engine 2016 Redistributable and install
Close SQL Server Management Studio
Go to Start Menu -> Microsoft SQL Server 2017 -> SQL Server 2017 Import and Export Data (64-bit)
Open the application and try to import data using the "Excel 2016" option, it should work fine.
Hope this ...
1
You could have a meta data table that stores the file name, processing date, and last modified date. Then you can have your job run daily and identify whether the file's last modified date is greater than the stored value.
If the file hasn't been modified in 32 (arbitrary number but base it on business tolerance) send a notification to you and/or the ...
1
I would consider moving away from MS Query/ODBC in general, and start using PowerQuery and yes, learn some of the "M" Language too. Excel is moving away from ODBC (my hunch from other blogs. Nothing official yet) and old DLL-style technologies, so it's worth catching up and going from there. Also you might consider PowerBI and really step away from ...
0
create table test.Table10 select mm.myid,mm.id,mm.type1 as GESTURE,MM.CHARSQ,MM.TYPE2 as TYPEDCHAR,MM.MYCHAR,MM.XCOR,MM.YCOR,MM.SLOPE,l4-(l2*(SLOPE)) as Intercept,
if (ANGLE1<0, (ANGLE1+360) , ANGLE1 ) as ANGLE0,MM.DISTANCE,MM.DW,MM.INDDIFF,MM.TIME1,MM.SPEED,MM.SPDFILT,MM.TIMETYPE from (select c11.*,((YCOR-l4)/(XCOR-l2)) as SLOPE,MOD(DEGREES (ATAN2((YCOR-...
Top 50 recent answers are included
