Have a linked delimited text file with
several thousand rows.  Text
file is created from IBM main frame.
There is one row ("header row")

good day all..
  I use my DB to track my checking account and I download and manually
import files from my checking company.
 would it be possible to automate that process? I would like to be able to

I am importing file that has date and time fields in the long integer format
as follows:
Date_occurred    Time_occurred
20051109           04562

I have several reports I am generating that management would like to have in
pdf format.  It is easiest for me to create the reports in Access, large
datasets, and then convert the reports to pdf format.
I am on a Win00Pro machine using Access 2000.  May upgrade soon to WinXP and

Linked Table Manager Issue
I am trying to change the links from my linked table manager (Tools >
Database Utilities > Linked Table Manager) to a different Access data file.
I can easily see that the tables it is linking to are incorrect.  They are

I have A SQL database with a Contacts table of about 2.9 million records.
I  setup a project in access linking to the SQL database.
Of the 2.9 Milion records in the contacts table, i need to retrive the
customers with a activitycode of Convert Only in the table, .Maybe 300,000 to

I have a report which has a list of times, in 15 minute increments, and the
number of calls received by a call center for each interval.  The reporting
database removes times where there were no calls.  I want to add the times
and zeros back in.  

I am using Win00Pro with Access 2000 currently, will probably upgrade to 2003
in the near future, so if there is a way to do what I need please respond for
both versions if different.
I have multiple table and/or queries that I wish to export into the same

Exporting a file in delimted txt format saved
with the .txt extension.
File name is created as "Program1.txt"
File needs to be uploaded to IBM machine

I have a structure that brings in excel data, Time Vs. Channels with
the cells holding measured values.
I have in the neighborhood of 750 channels ( 3-4 worksheets). And a ton
of records (1000's)

ACCESS 2002.  WHEN IMPORTING AN ALPHA NUMERIC FIELD FROM EXCEL TO ACCESS THE
NUMBERS ARE #'S.  YET IF I IMPORT ONLY A NUMERIC FIELD FROM EXCEL TO ACCESS
THE NUMBERS ARE CORRECT.  

I am trying to send an access report as an excel attachment(as the recipient
does not have MS Access). I went ahead and exported the  report to excel and
was successful  , however, one of the contents of the fields in the report
got truncated when exported. The field is a memo ...

Why doesn't the following work, but stop with a run-time error 3027 'cannot
update. database or object is read only
strPath="C:\Data\GSEXP\"
strFile="21WS.CSV"

Can Access 2003 use an XML Web Service as a data source. I amabout to start
creting some web srvices and would like to use existing acess databases to
view the data

Can Access 2003 use an XML Web Service as a data source. I amabout to start
creting some web srvices and would like to use existing acess databases to
view the data