Is there a simple way of getting a set of data to be emailled directly
to me through a SUBMIT button?  I have an Access form that gives easily
selected answer choices.  I want the form to be able to use a button I
found in Microsoft Publisher which submits via email directly to me.

I have an SQL 2k backend to my Access frontend (.mdb) using ODBC connections
to the database for years. Today I tried to link a new table and on the
pull-down for file types (File>GetExternalData>), I don't see the ODBC
listed! Did I just forget how to do this or did someone ...

Is anyone aware of an available (i.e., free!) database / data source
containing the list of COUNTRY NAMES acceptable to the US Post Office?
I would want something that's maintained periodically so I can refresh my
MDB a couple of times a year.

I'm using Access 2002 on WXP.
A double-precision number, 7 digits before the decimal and 3-8 digits after
the decimal (typical value - 2547855.6511) is truncated to the 7 digits
before the decimal and only two digits after. It is not simply dropping

I have individual spreadsheets for each day of the month for November.  Is
there a way to import them all at once into an access database?  
Thanks!

I'm importing 3 sheets from an Excel file.  All of the sheets pull data from
one other sheet inside the workbook.
The import works perfectly if the Excel file is open.  Here is the basic
outline of what I am doing:

Is there any way for Access to read the row heading instead of the
column headings when using DoCmd.TransferSpreadsheet. I have an excel
sheet with the information cantained going down the spreadsheet instead
of across and need this information transfered to my database.  Is this

I can not longer link any tables in my MS Access 2003 version.  It appears to
be a software problem.  I downloaded the trial version of 2007 and it works.  
I attempted to reinstall version 2003 with the CD supplied by Dell when
purchasing my Laptop, but the CD does not work ...

We would like to create an MsAccess.Mdb in office 2000 to obtain individual
table details from Accpac Plus in Dos (an accounting program)?
This Access data will be used for viewing and printing and not for
accounting purposes.

My database is in a MS SQL Server which I want to update when I update
anything in the *.mdb...Would I want to import these tables or link these
tables?  Thanks for the help!

I need to import a table with its field descriptions. Is there an easy way to
do it?
Thanks.

I want to set the current directory of a file dialog window to where
the existing excel spreadsheet that is running the macro is.
It works fine on my local hd but when i try placing the file on a
network drive it sets it to MyDocuments.  This is bad... could someone

I am just finishing work on an Access database that gets some of its
information from a data service.  The supplied data comes in the form of a
tables only .mdb file that is download ed and unzipped.  In developing the
database I manually imported the tables I needed and renamed ...

i have a table  full of data that is uppper case data in  a few  coloums bu i
wantot t be first leter uppercase and the rest of the road lower case through
out the column

I am exporting a query to a fixed-width text file. I need to insert a
carriage return or linefeed into the record so that part of each record is
placed on a new line of the text file.