Problem saving in tab delimited format

  • Thread starter Thread starter Allen Clark
  • Start date Start date
A

Allen Clark

I have a spreadsheet that I want to save 27 columns of data into a tab
delimited text file. The problem is that the last two fields are blank (ie
nothing in the cells in the columns). I need these two columns in the txt
file because an import script into a SQL database requires these empty
fields to properly import the data. Is there a way to export the data with
the two additional blank columns. There are no column headers either, only
raw, tab-delimited data.

Thanks in advance,
Allen
 
Hi Allen
untested but try:
- add a heading row (inlcuding the two blank columns)
- save the file
- manually remove the heading row in the created file
 
Thank you Frank,

This is the solution that trial and error produced as well. I was just
hoping for some sort of more controlled/automated method. (It still beats
manually keying in over 28000 records into a new SQL DB!)

Thanks for the response and for sharing your time and knowledge with the
group. The next time I'm in Germany, I owe you a beer!

Thanks again,

Allen
 
Back
Top