Folks,
I'm new to databases, and created my first one by taking the Access Template
for Client Management from MS web site, adding a few fields to it and
creating a Customer Management DB to track interactions with our clients.

dont have a clue what im doing - any help?

After linking to an SQL Server table, all fields in all rows display
"#DELETE". I can import the same table successfully. What does the #DELETE
mean and how do I link to the SQL Server table to get the data.
Thank You.

i have an access database of about 600 tables...is there anyway i can export
all of the tables (and information) to excel on one worksheet. i need to
audit the information and remove old information.

 I am importing data from a CSV file that has 81 fields of data.  I am
trying to only import 14 fields but they are not together...  but scattered
across the dataset.  I see that access will allow me to skip data import on
selected fields but the field list it gives me looks ...

I have two text-files that I regularly import in a mdb. I have written
import specifications for both files. One of the files appends data on an
existing table and the other file replaces data in an existing table.
Can I write a macro to make Access do the following:

When linking to an AS400 file the link is unsuccesful due to too many indexes
- how do you correct this problem and link to the file.  Same prob if try
importing

I am needing to import a series of Excel workbooks with multiple worksheets
(each sheet has pertinent data).
I looked at the External Data -- Import
But it look for a header and my sheets are not 'flat'... Cell A11 has the

Hello,
I am trying to export reports, tables, etc from an access databast to excel.
The purpose of these reports and tables is to be put into another document
which is used as a manual.  Everytime that I export the information becomes

Hello, I am slowly learning.
I have a query that I am trying to export as a fixed length, text formatted
*txt file. I am looking at the Export Specifications and have entered the
desired lengths of the fields as follows. The fields have to be 11, 50 , 50,

I am working in Access 2003.
I have two tables tblBenchmarks and tblBenchmarkUpdates.
I need to update existing records in tblBenchmark and also add new records
if they currently do not exist in tblBenchmarks.

I need to update an Access database weekly from an excel spreadsheet
generated from one of our systems... In doing so, there is some basic
transforms to do one the data before it is dumped in...
Is there an easy/good way to do that?

Hi experts
when i export a query to excel 2003 the result file contains the date format
in "custom" format. here are 2 question
1) is there an export wizard for EXCEL?

Using Office 2003
I have an existing spreadsheet database and the first row contains column
headings. The data was keyed in from paper tickets where there were multiple
entries on the same ticket number. So there are several rows for ticket 1,

Is it possible to get the dsn system information from an odbc source using
vbcode.  Example: I have an ODBC connection to a database under by system dsn
tab, and would like to get that using vbcode.
Thanks in advance.