I have a directory containing 10,000 txt files that I have to import
for excel.
Any file have two lines and I need that they appear in excel as the
following:

I am currently using Excel's MSN Money plug-in to retrieve stock price
information daily into a spreadsheet. On one worksheet I keep updating and
adding to the data and on another I do various calculations based on the
data. Because the quantity of historical prices is getting ...

I am trying to export out multiple files with different width settings to
one text file.
I am looking for the code to do this within access. Some one told me to
export the files and then shell to the windows copy command to concatenate

Using ODBC I am able to link to Oracle database.  The table name in
Oracle is ITEMS.  When I do the link the user name is added to the
Name. Now the table name in Access is PPS_ITEMS.  The problem is that
if I need to move this Access program and connect to another database

i have upgrade my system from windows 2003 into xp.
at the present i am unable to import vack up files saved into D
not am i able to locate any files , folders and or the drive D.
help and thanks

I have been reading and searching trying to find how to do this.  I need to
read a table and create a text file with one row for each row in the table.  
Then I need to read a CSV .txt file in and place those values in a table,
row for row.

I've created a database in openoffice base 2.0. It has odb as an extension
and doesn't give me any other save options. Is there any way I can get it
into MS Access?

I have the following code that i found online.  What i am wanting it to
do is automation to copy records from excel to an  excel.  Please show
me how to change this code to bring recordsets from another excel file,
versus from a access table.

I want to add pdf files into an existing database. I want to do add a button
and by clicking on it access these files that I import into the database. How
can I do this?

Hi,
I have a contacts database built, I filter my contacts through a search
feature. At the moment I am exporting their email addresses through a query
to a word file, and then copy and paste into the To: field in Outlook Express.

I'm trying to import data from an Excel file to Access.  The help
instructions discuss using the "get external data" function from the "File"
menu in Access but this is not an option I have available.  I've downloaded
all the updates, etc. but have been able to correct the ...

There is a problem when access have to sort a table wich contains 100.000 or
more data fields. How can I fix it..?  
Ziva
Denmark

My boss has asked me to write a vbscript to parse data from a text
file, but the fun thing is I have 0 experience with doing anything like
this.  But here's the situation:
I have a batch file that downloads 3 files from an ftp site and then

i need tio know if there is any way to do this easier.
i have a large list of part numbers and quantity by month that i run a query
for in Access to create a cross reference spreadsheet in excel to total by
month and by part number.

I am trying to create a macro that will append records from one excel
spreadsheet to another excel spreadsheet with access 2003.  Later I am
going to populate some cells with an existing table in my access
program, but this is my problem for right now.  I want to leave all