question

ruancra avatar image
ruancra asked

Exporting Excel to .txt (Tab Delimited)

Hi guys I'm having an issue when exporting multiple spreadsheets to txt format. When exporting a sheet as a tab delimited text file, it exports a lot of white space also. Is it possible to export a excel spreadsheet as tab delimited, without the extra white space? Thanks Ruan
export-dataexportdata-exportdelimitertab-delimited
4 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

GPO avatar image GPO commented ·
You're question doesn't seem to be about importing data into SQL Server. This is a SQL Server forum. It's probably the case that a lot of SQL Server users are also proficient at using Excel, so you might get lucky and find someone here willing to answer your Excel question. I reckon you'd have more luck asking an Excel question on an Excel forum. Just sayin'
3 Likes 3 ·
Gazz avatar image Gazz commented ·
It also relies on electricity, but I don't see anyone here asking how to wire a plug!
2 Likes 2 ·
GPO avatar image GPO commented ·
How does this relate to SQL Server?
1 Like 1 ·
ruancra avatar image ruancra commented ·
SQL Server relies on data doesn't it?
0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.