Recently my  company upgraded it computers, but not Office (not yet anyway).  
In the new Hard Drive image, Access 97 will not import text files (yes it did
it on the older systems).  You can begin the import process, choose the .txt
extension, but when you select the file and ...

I am using Access97 to save query results to a fixed-length file.  Here is
the command:
DoCmd.TransferText acExportFixed, "ItemUPC Export Specification",
"qryItemUPC", txtOutputFileName, False, ""

I am working in Access 97. The following line is giving me an error message.
DoCmd.SendObject acSendTable, "tmpExcelEmployeeReportTo", 8,
rs("EmailAddress")
The message is Error 2282: The formats that enable you to output data as a

I have a file that is a .csv that is linked to my database.  I want to
change it to an import and am not sure what specification is being used, is
there a way to find out which one it uses?
thanks

I have a query used to update our mySQL database online. One "created" field
in the query takes information in many different fields in the table and
creates a description. For example, if field A, B C and D stores the value
90, excellent, Null and 135. The description built would ...

In Access 2000, I'm trying to import tables from Word/Excel into a table for
use in Forms.  I don't want to have to insert unquie characters into the
paragraphs, import it, and then manually change each one.  Isn't there an
easier way?

I run a routine daily that exports a table into Excel. I would like the Excel
file name to be:  rehab_mm-dd-yy.xls where mm-dd-yy is derived from the value
of one field in the table being exported.  I don't think I can do that using
transferspreadsheet in a macro, but can I do ...

I have created a macro for a transfer spreadsheet action, type export.
When setting the action arguments at the bottom, in the file name argument;
how can i set the file name arguement so that it uses todays date as part of
the file name?

I am running a Windows XP Pro and Office XP Pro machine with Microsoft Access
2002.  I currently use a database to import records from a web based database
by saving downloads as .csv files, converting to excel, cleaning up the data,
and then importing the Excel File via VBA Code ...

I am exporting data from Access to a Pre-formatted spreadsheet created by out
financial group (I cannot change it). They put a macro on the spreadsheet so,
every time we open it, the Excel asks me to enable/disable the macros.
My problem is, when I open the spreadsheet from my VBA ...

When I import text files with French accents in Access 2003 database the
French accents are converted to symbols. What can I do to prevent this from
happening.

Can and how do I filter records from a text file for input into an access
table?
I have a 2.7 million record dataset which is approx 1.2 gb that I need to
get into Access but I only require records that match a particular criteria.  

Whenever I try to create a linked table in ms access 2003 to any contacts
folders I receive an error message : Access has encountered a problem and
needs to close.
I am in an exchange server environment, and the contacts folder is on the

Is there anyway to import an excel spread sheet into an already existing
access table?  Thanks in advance.

Does anyone know if Access 2003 has a text import setting similar to the
"start import at row" functionality found in Excel? By reading though
previous postings, I have seen some people suggest code to remove any
unwanted starting rows. I was hoping there was something a little ...