Need a batch file to import text file to excel sheet. HELP!!

February 1, 2012 at 21:28:04
Specs: Windows XP

Hi
i need a batch file to import text file to excel sheet.
Plz help.

Thanks
Adi



See More: Need a batch file to import text file to excel sheet. HELP!!

Report •

#1
February 2, 2012 at 02:47:44
Delineate your column information with tabs in your text file.

A fast way to do this is with "Find and Replace...". Then type a space in the "find" field and a tab in the "replace with" field, then click on "Replace" or "Replace All" as appropriate.

Then put this in your batch file:

copy %1 %1.xls > nul
excel %1.xls

and issue this in a command window:

mybatfile.bat D:\path\myfile.txt

Use your own drive, path and filename.

Report •
Related Solutions


Ask Question