Help me, pls...

N

nasim

anybody know how to use MS Access to convert anything (from) such as,
MS. Excel, etc to produce .txt?? i've no idea about this.

if there is somebody could help, pls.. help me:(
thanks b4.
 
S

Steve

Look in the MS Access Help file ---
TransferSpreadsheet function - importing from and exporting to Excel
TransferText function - importing from and exporting to a text file

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
[email protected]
 
J

John W. Vinson

anybody know how to use MS Access to convert anything (from) such as,
MS. Excel, etc to produce .txt?? i've no idea about this.

if there is somebody could help, pls.. help me:(
thanks b4.
Click to expand...

You can use File... Get External Data... Import on the menu to import data
from an Excel workbook into an Access table; then you can use File... Export
and select .txt as "files of type" to export it to a text file.

Not knowing anything about your spreadsheets, the nature of the data, or the
desired format of the text file, it's hard to be very specific!

John W. Vinson [MVP]
 
N

nasim

You can useFile... Get External Data... Import on the menu to import data
from anExcelworkbook into anAccesstable; then you can useFile... Export
and select .txt as "files of type" to export it to atextfile.

Not knowing anything about your spreadsheets, the nature of the data, or the
desired format of thetextfile, it's hard to be very specific!

John W. Vinson [MVP]
Click to expand...

thanks, john..,
here the situation, i just asked to create simple program using MS.
Access (i wonder if i could use Access to create program, i've no
idea). the program is basically, to convert anything, but usually data
in .xls, and output must be in .txt.
i even don't know from where i can start create it. looking to access
that has VB, is it possible to use it to create it?

hope you can guide me about that,
great thanks b4.
 
J

John W. Vinson

here the situation, i just asked to create simple program using MS.
Access (i wonder if i could use Access to create program, i've no
idea). the program is basically, to convert anything, but usually data
in .xls, and output must be in .txt.
i even don't know from where i can start create it. looking to access
that has VB, is it possible to use it to create it?
Click to expand...

If you want to take any arbitrary, unpredictable spreadsheet, and use it to
produce any arbitrary, unpredictable kind of text file, then neither Access
nor any other program I can imagine could possibly do so.

Excel can produce output in text format - why involve Access at all? I suspect
Access is the wrong tool anyway: its purpose is to manage data in databases,
typically carefully designed relational databases; you may well import and
export data from the database, but it sounds like you don't care about storing
the data at all, just transforming data from "anything" into .txt files.

Could you please be more specific about what data you will be transforming,
and into what you wish to transform it? As stated, the task is so broad as to
be undefined!

John W. Vinson [MVP]
 
Top