Here is my problem.  I would like to take a field that contains a 3
digit word, space space, 3 digit word.  For example "F4M  &X7".  Is there
anyway I can delete one space of the spaces through Update Query?  Your help
is much appreciated.  I know that I can create another ...

I am trying to export an Excel file (4 worksheets) to a single Access table.
The code I use is the following:
DoCmd.TransferSpreadsheet acImport, , "DataImport", FileName, False,
"Sheetname1"

People -
I am having a mental block..and I need your help.  Does the below
'expression' will work when you have the following data field:
Data Field = Country

Getting an error message 31519 when trying to import a file.  Need help in
determining how to correct problem.
thanks

I am trying to either import the contents of an Access query (a list of email
addresses) into the "To" field in a new Outlook message or to export from an
Access Query.  Is this possible?

I have a database with over 100 queries in.  Is there a way to export a list
of the names of the queries to Excel or a text file?

Is it possible to automatically load a table with data from a csv or excel
file?
I want to automate a data entry process.  Everday I recieve an excel
spreadsheet containing data that I have to manually insert into a table.  I

Hey guys & gals (if any) this is my first posting to the group.
Got a nagging issue that I am trying to resolve.  Google and Newsgroup
have not posted anything that can resolve what I need to do.
I have an AS/400 system here that has a date format of CYYMMDD.  The C

Can a Schema.ini file be used to import into a new table or just existing
tables.
I am using the "How to create a schema.ini file programmatically" at
http://support.microsoft.com/default.aspx?scid=kb;en-us;155512, which works

When I am try and import date from a spreadsheet into an existing table, I
receive and error message and it will not import the data.  I have check data
type and field names.  
Thoughts

I am trying to import a spreadsheet from Microsoft Excel.  Some of the fields
are blank.  The import itself works perfectly except I get import errors
(type conversion failure) for the blank fields.  Any suggestions?

When export a report from an Access 2000 database to Excel 2000 a notes field
is being randomly truncated i.e. not all the data in that field is being
exported. Has anyone come across this and do you have any idea of a fix?

Hi, I have an Access report, which contains detail and a "project" group
footer.  I hide the detail and just see the footer data in the report.  I
want to export this data to Excel, but when I do all that shows up in Excel
is 1 row with the words "text x" (where x is a number), ...

I used this code to export my query result to Excel
Dim XL As Object
     Set XL = CreateObject("Excel.Application")
     DoCmd.OutputTo acOutputQuery, "qryName", acFormatXLS, "C:\Result.xls",

Here is what I am supposed to accomplish:
I have a Corrective Action Database.  We e-mail out the Corrective
Actions (A Report) to individuals to fill out in word, through the e-
mail function in Access.