LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Import and Export Text data

Hello All, I have a text file that contains 17 lines of header
information and then a bunch of data from rows 18 on. I need to import
the data to remove one column and the re-export the data as a text
file, I can do all of this manually but I wanted to try and automate
the process as it takes up way to much of my time to do this everyday
with all the data.

Here is my ultimate goal:

1-Import the text file and save the header information to attach to
the text document that is exported.

2- Delete column E after importing the raw data starting at row 18

3-Put the header information back on top of the data and export as a
text (tab delimited) file.

If anyone wants I can email the text file it is too big to post here.

Thanks,
Bob
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Import / export data Levi New Users to Excel 2 January 13th 09 06:14 AM
How to Start Excel in Text Import Wizard for data import rlelvis Setting up and Configuration of Excel 0 July 10th 08 08:40 PM
Import/Export ecruz04 Excel Discussion (Misc queries) 1 April 27th 07 08:17 AM
import/export data from a workbook ajn Excel Discussion (Misc queries) 1 December 8th 06 01:44 PM
data import and export in to access nuti Excel Discussion (Misc queries) 10 January 5th 06 07:09 PM


All times are GMT +1. The time now is 09:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"