I am trying to run a UNION ALL query in SQL SERVER 2014 on multiple large CSV files - the result of which i want to get into a table in SQL Server. below is the query which works in MSAccess but not on SQL Server 2014:
what error messages are you getting?
what is the reasoning for doing union and calcs on the csvs?
maybe better to import each csv to a single staging table in SQL and work from there?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day