How do I take a simple list in Excel and transport it to Publisher to make
labels? I have about 80 people in my company and I don't wan to type in each
address if I don't have to.  Thanks.
Cornelius Pittman

Hi
I am trying to use the transfer spreadsheet function to export a crosstab
query to a named worksheet in a workbook.
The worksheet already exists and when i call this function it creates a

I have a question regarding the capabilities of Access and I would
appreciate any suggestion.
This is the problem:
I need to create a project which upload (monthly) a text file (with

I have a problem to export Access data to SAS. I only can export some part of
the data. For example, I have 230 records. I only can export the first 35
record. The 36th records only include the id but no data. I suspect the 36th
record was corrupted. When I get in the Access ...

I have a form where the user enters a name of a word merge file, begin data,
end date and event type.  I have a command button which then process the
following code in the on click event (ingore the line wrap).
  Set objWord = GetObject("c:\Mailing List\" & Forms![Report

I am looking to create an MSSQL database that has an Access 2000 front end.
The client side Access app needs to download selected bits of data from the
SQL database and the clients would work offline with this data and later
when they re-connect the data would then need to be ...

Does anyone know how I can change the field type of an
Excel table that I have linked to my Access database. The
field concerned is a descriptive field that I would like
change from 'Text' to 'Memo'. Hope someone can help.

When I use the access 2003 Linked table manager it is empty.

Greetings! I am querying linked Oracle tables from Access 2000. One of the
tables that I am querying has a new column added to the structure every month
to record end of month data (terrible design, but I didn't build it). I need
to sum all of the columns using SQL for each ...

Having a problem linking Access 2003 to a FoxPro database. Have read the bits
in the knowledgebase about using Visual FoxPro ODBC to link instead of
linking directly. The only snag is I can't seem to load the FoxPro ODBC
driver in Windows XP. Checking this out I seem to be ...

How can I verify if one specific sheet is inside the spresdsheet?
I need to verify if it exists, otherwise a error message of "Out of range"
appears and it does not make much os a sense to my users.
To open the Excel file I am using:

With Access 2002, after I successfully link to an Excel Spreadsheet, and I
look at the Table design of my linked Excel spreadsheet, some of my columns
list incorrect Data Type.  For instance, the 1st column of linked table shows
"Number" as my Data Type, however, the data in my ...

I am importing contact information data from Excel. The phone numbers in the
excel spreadsheet have been entered inconsistently. Here are examples:
(xxx) xxx-xxxx
xxx-xxx-xxxx

Res.All,
   I want to use Yield function present in the Analysis toolpack add-ins of
Excel in an access application. How can I do it?
   Or, can anybody send me the formula used behind that function?