Importing text problems

  • Thread starter Thread starter Allan Fischler
  • Start date Start date
A

Allan Fischler

Hello,

I am trying to import a list into Excel, and having trouble getting past the
import wizard. The data seems to be separated by various symbols, and I
cannot seem to separate my data so it imports to a useable form.

Wondering if I could send a sample of this data (text file) to someone
proficient in Excel to try and import? Any help would be greatly
appreciated.

Thanks very much.
 
If the number of delimiters is limited (pretty small???), then maybe just open
the text file in your favorite editor and do some Edit|Replaces to make all the
delimiters the same.

It might be easier to just fix it outside of excel.
 
Sorry for breaking in.

I have tried to open a CSV using the Workbooks.OpenText. But it always
open the CSV as if it was open in the OPEN DIALOGBOX and don't follow
the settings I have used in the OpenText action. I have no problem in
opening a .TXT file using the same command line. Is that normal? (I am
using Office 2000)

Currently I have to FileCopy the CSV to a TXT first before open it
using Excel.

The reason why I need to do so is because one of the column in the CSV
need to be treated as TEXT or else all the "000123" like invoice
number will become numeric value '123.00'.

Thanks.
 
Yep. That's the way macros work with .csv files.

Could you just rename the .csv to .txt (not much better, huh?)

Look at Name in VBA's help if you want to try that.
 
Thanks. Sad to hear that this is the "auto" funciton of VBA.

But the reason why I don't want to NAME it because I want to keep it
as ".CSV" and other software will use it.

Of cource I can NAME it back to .CSV after I have finished using it,
but usually I will forget ... So now I just COPY it to another TXT to
use it in Excel.

Thanks.
 
Back
Top