Read File - Microsoft Access / VBA

colleen1980

Hi:Can any one please tell me how to convert excel file into a text
file thru VB6 Program? Also is it possible that i read the values from
the converted text file of any column one by one thru do while loop?
Or can i read the values of any column directly from excel file
without converting into a textfile thru do while loop?

Thanks,
Anna.

Mar 9 '07 #1

Subscribe Post Reply

3372

Allen Browne

You can attach the Excel file. Choose Get External on the File menu.

Once attached, you can create a query to find the record you want, and read
the value from the field.

If you want to export it to a text file, use TransferText in a macro to
export the attached Excel "table."

If you really want to read a text file line by line, see help in the VBA
window on Open.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<co*********@gmail.comwrote in message
news:11**********************@h3g2000cwc.googlegro ups.com...

Hi:Can any one please tell me how to convert excel file into a text
file thru VB6 Program? Also is it possible that i read the values from
the converted text file of any column one by one thru do while loop?
Or can i read the values of any column directly from excel file
without converting into a textfile thru do while loop?

Thanks,
Anna.

Mar 9 '07 #2

Similar topics

read from file or mysql

by: Yang Li Ke | last post by:

Hi guys! I have some datas that I must check everytime a visitor comes to my site What is better to do: 1- Read data from a file or 2- Read data from a mysql db Thank you

PHP

Help with "read" issue please

by: ZafT | last post by:

Thanks in advance for any tips that might get me going in the right direction. I am working on a simple exercise for school that is supposed to use read to read a file (about 10 MB). I am...

C / C++

Simultaneously Write to and Read from the same file

by: cnu | last post by:

My program generates a log file for every event that happens in the program. So, I open the file and keep it open till the end. This is how I open the file for writing: <CODE> public...

.NET Framework

Which way is best to read from a file?

by: ESPN Lover | last post by:

Below is two snippets of code from MSDN showing how to read a file. Is one way preferred over the other and why? Thanks. using System; using System.IO; class Test { public static void...

ASP.NET

Write/Read struct to file

by: a | last post by:

I have a struct to write to a file struct _structA{ long x; int y; float z; } struct _structA A; //file open write(fd,A,sizeof(_structA)); //file close

C / C++

Check if program finished to read a whole file

by: lovecreatesbea... | last post by:

The condition at line 31 is added to check if the program finished to read the whole file. Is it needed and correct? Thank you. #include <fstream> #include <iostream> #include <string> using...

C / C++

how to read wav.file and put it into byte array and do the DFT?

by: lovecarole | last post by:

hi, i am the student who should write a program about reading wav file and do the DFT. actually i don't know how to read data of the wav song and save it into the array... if i want to read...

Java

Fast way to read a text file line by line

by: Thomas Kowalski | last post by:

Hi, currently I am reading a huge (about 10-100 MB) text-file line by line using fstreams and getline. I wonder whether there is a faster way to read a file line by line (with std::string line)....

C / C++

read xml file from compressed file using gzip

by: flebber | last post by:

I was working at creating a simple program that would read the content of a playlist file( in this case *.k3b") and write it out . the compressed "*.k3b" file has two file and the one I was trying...

Python

Unable to read large files from zip

by: Kevin Ar18 | last post by:

I posted this on the forum, but nobody seems to know the solution: http://python-forum.org/py/viewtopic.php?t=5230 I have a zip file that is several GB in size, and one of the files inside of it...

Python

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++