Windows 10: Azure synapse serverless sql pool create external table from csv file, but csv contain wrap.

Hi,I want to create a external table in synapse serverlesss database , the data souce from storge csv file. for this csv file have some wrap in a column caused a error while load data, error message: Bulk load data conversion error type mismatch or invalid character for the specified codepage for row 2, column 24 ID in data file.....Let me type special content here from that column. and can you help? attached the column included the data dummy data here:CUUITED STAOCT LABEL SEWN ,LEL, O TRAIX HE N, S T: - Y F IN SL E N T FRO SE O T L IN H - C BE IF OR PRINTED WITHL - FK, CK. FS, CD. F

:)

 

Open CSV file

Sadly dkAUS .CSV files aren't supported in WP8 devices. There's already a suggestion on the official Windows Phone suggestion page, so you can vote for it here:



http://windowsphone.uservoice.com/forums/101801-feature-suggestions/suggestions/3383829-please-allow-excel-support-csv-files-in-phone-8

 

Combine multiple CSV files by column, not by row

I have ~100 CSV files that I want to combine into one single Excel spreadsheet (everything in one tab, not in separate tabs). These CSV files are identical in format: each contains 4,000 rows and 2 columns with header, about 60 KB in size.

All solutions I've found so far append the next CSV at the end of the last row of the active tab. I haven't seen one that can append new CSVs to the columns immediate to the right of last column.

Here're some examples.

1. DOS copy method: copy *.csv merge.txt
   
2. This solution. (VBA script.)
   
3. Using Excel's Data>New Query>From File>From Folder (Excel 2013) .
   

There are also examples with Windows Powershell scripts to merge CSV files on the internet.

All of the above create a single Excel spreadsheet with about 400,000 rows of data, which is useless to me.

I'd appreciate suggestions to solve this problem. Thanks!

Edit. An easy solution is found: using r's cbind() to combine the data in a data frame and then write it to a csv. The entire process took ~3 seconds. Right tool for the job!

Thanks to everyone for contributing. Cheers,

--tcollar

 

CSV files used to open in Excel....not now!

Hi, you say Excel is installed. Does it run normally?

You can't find Excel in (an unspecified) list of applications. I don't know which list that is for sure.

For example, in the list related to:
- rt click a file. Open With
- this list:



- this list:




- some other list...

If Excel does not appear in the above, I suggest you repair your office installation.

Maybe the above gives you some ideas. Otherwise please post a screenshot of where you think you should see it but don't. Thanks.