I have a number of files - 2600, which grows by at least 20 every day -
that have about 140 fields each. The first line of each csv file
contains the field names, pipe delimited. The second row of each file
contains the values for each field, also pipe delimited. I have a

I have several applications that import Excel files into Access, some
automatically importing a large number of files. I've scheduled the update
process for a time when no one should be in these files, but occasionally
someone has the spreadsheet open and I'm unable to load it ...

I have 2 questions
1.    I am trying to automatically create a workbook with a number of
sheets in it with different data. I see how the command mode allows you
to feed data to a (one/first) sheet (C:\Program Files\Microsoft

I am building a database in order to track all appropriate information
for my newpaper subscribers, carriers and related items.
All of my data is being pulled from an excel spreadsheet which has been
modified to hold the data in a format Access should be able to identify

I created a field in my query using the following function:
Dealer to Install: HolidayWorkDayDiff([Date Dealer Rec'd Equipment],[Install
Date])
When I run the query it returns exactly what I am looking for, but when I

My goal is to import data from multiple (several hundred) Excel files into 1
Access database.  All Excel files would have the exact same format; only the
values would differ.  Is this possible?
Let me know if you require additional explanation.  Thanks in advance.

I add data to a table of access by reading an excel sheet.
I have to add a record to the table.
Sub readexcelsheet()
Dim db As Database

I backed up my data to another table, then proceeded to try and send data to
an archive group; in which case it failed and I lost all the data in my
table.  So I imported the backed up data, and it imported fine.  However,
reports and queries are not pulling the data.  Any ideas? ...

I start to use Microsoft Outlook for my mails and I need to get addresses fm
Outlook Express to Microsoft Outlook.  I couldn't find "Import" or "Export"
fm the File list to get the address book. How can I get my address book fm
Outlook Express ?  Pls help !

I'm exporting a query to a delimited text file.  The query has a date field
which is formatting a field to (Format([sTime],'mm/dd/yyy').
My problem is that when I run the macro to export the data, the date field
is exported in quotes "06/29/2005".

Does anybody know how to get a Clarisworks 4.0 (for Windows) database into
Access (XP), while maintaining some, most, or all of the formatting of the
database?  I would rather not start from scratch.  Thanks.

I have the following table that I would like to export to Excel:
Town                     Name
Bellmore              John
Freeport               Paul

I'm trying to import the attribute table of a shp-file - that is a dbf-file
(from ArcGIS 9.0). It's worked many times before, but now it suddenly
doesn't. I'm trying to figure out what's different about this shp or dbf.
Often I get the message Access can't find the file and to ...

How can I convert a ms works data base file so that I can e-mail it to others
who have nothing but ms office?  They cannot open works files with office.

I've just discovered the schema.ini file. I'm wondering if it can help out
with a problem we have.
We have an application that we have on a remote system shifts out data as
CSV files but does not provide any column headers.