Mobile menu

import data from text file to excel(VBA),
Thread poster: topr
topr
English
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
Poland
Local time: 02:24
Member (2002)
English to Russian
+ ...

MODERATOR
Moving the topic Aug 24, 2004

to the Office Applications forum.

Direct link Reply with quote
 

Harry Bornemann  Identity Verified
Mexico
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






Across v6.3
Translation Toolkit and Sales Potential under One Roof

Apart from features that enable you to translate more efficiently, the new Across Translator Edition v6.3 comprises your crossMarket membership. The new online network for Across users assists you in exploring new sales potential and generating revenue.

More info »
WordFinder
The words you want Anywhere, Anytime

WordFinder is the market's fastest and easiest way of finding the right word, term, translation or synonym in one or more dictionaries. In our assortment you can choose among more than 120 dictionaries in 15 languages from leading publishers.

More info »



All of ProZ.com
  • All of ProZ.com
  • Term search
  • Jobs