Results 1 to 2 of 2
2001-08-28, 08:57 #1
- Join Date
- Jul 2001
- Thanked 0 Times in 0 Posts
Transfering Data Into Corresponding Fields (Excel 2000)
hope to get some helps. i will import a deliminated text files into a worksheet. The data from the txt files
will be in the layout base on the following tables:
currency_code 4 char,
thus, sample data would be :
Once i imported the text files into the worksheet, i need the data to be placing
into the respective columns eg:
<pre>currency mth year exchange rate mth year exchange rate ......
USD JAN-2001 1.83 FEB-2001 1.79
USD JAN-2002 1.80 FEB-2002 1.80
USD JAN-2003 1.79 FEB-2003 1.79
I have attached a sample excel table. how can i do this tasks...
thanks in advance..
**edited by Rory:
I have copied the attachment here from the cross-posting in VB/VBA/.Net**
2001-08-28, 12:27 #2
- Join Date
- Jan 2001
- Redcliff, Alberta, Canada
- Thanked 5 Times in 5 Posts
Re: Transfering Data Into Corresponding Fields (Excel 2000)
Have you tried the text import wizard in Excel? It launches automatically when you open a text file.
Cheers[b]Catharine Richardson (WebGenii)
WebGenii Home Page
Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile