I am using Office 97.  Have successfully imported from Excel to Access many
times.  Today I have encountered a problem.  After the import wizard is
finished I get an error message stating " An error ocurred trying to import
file C:\My documents\abc.xls  The file was not imported" ...

I have a text file with fields delimited by |
When i do a straight import and look at the table data types some are text
and some are date/time (with no format) the dates that come look as they do
in the text file 2005/10/30.

Is there an elegant way to verify that I an ODBC connetion is valid?
THe approach that I've used previously is to used the
"DoCmd.TransferDatabase..." command, and trap any error as a failure.
Any feedback would be appreciated!

I need to find the number of carriage returns in a memo field.  Is there a
canned function to do that?

I know the topic of importing Excel spreadsheets into Access has been
covered in this group but I was wondering if anybody can help me with a
spreadsheet I'm trying to import. I plan on using the
Docmd.transferspreadsheet command, but I need to figure out a few things.

I have an external database (Ms Database)  protected with password. I want to
pass a SQL from current database. how can i pass the password;
For example: SELECT StudentsMaster.SurName
FROM StudentsMaster IN 'c:\Nestor\Nestor.mdb'; works if i had removed the

I'm generating an XML file to be imported into an accounting program using a
COM object that reads XML files. The </TRANSACTION> (end transaction) should
show up after the Detail, Payment, and Tax sections but appears before the
first Detail section. I do not understand why this ...

I have a database that I would like to link to a personnel system and import
PURE EDGE IMT forms. As I enter an employees information I'd like three
different PURE EDGE forms updated at the same time with just one entry.

if it is possible, how would i go about creating routines (storedprocedures?)
that can be invoked from a microsoft access ADP file that will backup (and
hopefully have the ability to also restore) a SQL Server database?
thanks for any and all help!

Does anyone know a way to turn of all warnings when using the Output to
feature of a macro?  I am trying to out but query results to a specific excel
file.  I always want to overwrite the current file but do not want to have to
answer the question" File X already exists.  ...

Is it possible to export pictures from Access. I imported pictures using
photo editor and clip art. The clip art pictures say that they are in the
soft clip gallery. I really need these photos as jpeg or gif format.

I have a data base that users open and need to import information from an
Excel worksheet. They are not allowed in the design mode of the data base.
When they open the data base, there is no where on the toolbar to be able to
accomplish the importing of the excel worksheet. I ...

I have seen a link from Access to table on a SQL Server 2000 database.
I have not checked, but are these links to table data readonly?
I am disturbed if our SQL Server database tables can be changed by external
users

I have one particular column that only shows data in part of the rows.
In Excell, the format property indicates the data is in text.
They looks like this:
0012

A database is already set up with form tailored made.  How can I import the
data from excel to the database?