Mobile menu

import data from text file to excel(VBA),
Thread poster: topr
Aug 24, 2004

hi !
how can i import data from text file to excel(VBA), as my data has commas ,qoutes delimiters .
thanks in advance.

Direct link Reply with quote

Natalie  Identity Verified
Local time: 05:35
Member (2002)
English to Russian
+ ...

Moving the topic Aug 24, 2004

to the Office Applications forum.

Direct link Reply with quote

Harry Bornemann  Identity Verified
English to German
+ ...
I know what you mean.. Aug 25, 2004

If you cannot open the file directly in Excel, you will have to use Word or a good text editor for a search and replace operation to change the delimiters. I use tab delimiters without quotation marks to copy and paste such a table via Clipboard into Excel. You will still have to check the results and occasionally correct any mishaps.

Direct link Reply with quote

To report site rules violations or get help, contact a site moderator:

You can also contact site staff by submitting a support request »

import data from text file to excel(VBA),

Advanced search

Wordfast Pro
Translation Memory Software for Any Platform

Exclusive discount for users! Save over 13% when purchasing Wordfast Pro through Wordfast is the world's #1 provider of platform-independent Translation Memory software. Consistently ranked the most user-friendly and highest value

More info »
Manage your TMs and Terms ... and boost your translation business

Are you ready for something fresh in the industry? TM-Town is a unique new site for you -- the freelance translator -- to store, manage and share translation memories (TMs) and glossaries...and potentially meet new clients on the basis of your prior work.

More info »

All of
  • All of
  • Term search
  • Jobs