Reading a text file
Help! :(
Is there a way to automate the importation of a text file in to Excel, with out having to use the import text wizard every time? Below is a sample the the file and the inofrmation I need. ( the file is actually much larger then this) but this will give you an idea. The actual numbers will change from day to day,and so will the amount of rows. But the file format and the number of columns will always be the same. and the information I need will always be the same columns. I've read books, tutorials and even information on dos batch files. :( I'm stuck, I have my whole spread sheet planned out. All my reports and summarys but it's usuless without the ability to import this information. SOMEONE PLEASE HELP !!! Thank you. WTG. SAMPLE: Actual Text File: 000000000 07:5007:50 PON 0000<MN22400130 000000000 08:1608:16 PON 0000<MN22400140 000000000 11:2211:22 PON 0000<MN22400120 000000000 11:4711:47 PON 0000<MN22400115 000000000 06:1306:13 PON 0000<MN22400155 Actual Information needed: 07:50 PON 22400130 08:16 PON 22400140 11:22 PON 22400120 11:47 PON 22400115 06:13 PON 22400155 |
WTG,
Yes. You can use a query, and import the text into your workbook. To re-read the file, refresh the query. It's all at http://www.smokeylake.com/excel/textfiles.htm. Read "Reading a text file into Excel." -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "WTG" wrote in message ... Help! :( Is there a way to automate the importation of a text file in to Excel, with out having to use the import text wizard every time? Below is a sample the the file and the inofrmation I need. ( the file is actually much larger then this) but this will give you an idea. The actual numbers will change from day to day,and so will the amount of rows. But the file format and the number of columns will always be the same. and the information I need will always be the same columns. I've read books, tutorials and even information on dos batch files. :( I'm stuck, I have my whole spread sheet planned out. All my reports and summarys but it's usuless without the ability to import this information. SOMEONE PLEASE HELP !!! Thank you. WTG. SAMPLE: Actual Text File: 000000000 07:5007:50 PON 0000<MN22400130 000000000 08:1608:16 PON 0000<MN22400140 000000000 11:2211:22 PON 0000<MN22400120 000000000 11:4711:47 PON 0000<MN22400115 000000000 06:1306:13 PON 0000<MN22400155 Actual Information needed: 07:50 PON 22400130 08:16 PON 22400140 11:22 PON 22400120 11:47 PON 22400115 06:13 PON 22400155 |
Many Thanks, I'll try it
On Mon, 21 Feb 2005 19:50:52 -0500, "Earl Kiosterud" wrote: WTG, Yes. You can use a query, and import the text into your workbook. To re-read the file, refresh the query. It's all at http://www.smokeylake.com/excel/textfiles.htm. Read "Reading a text file into Excel." |
All times are GMT +1. The time now is 07:45 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com