Alright I am trying to set up a database for work for my coworkers to use.
That means I have to make it as simple as possible for them to understand how
to use it.
What I would like to do is this:

I have a large worksheet (15k items) that relate to law books, some of which
were published during the mid-1800's.  I am trying to export this data from
Excel into Access.
The columns are formatted as date/time in Excel (mm/dd/yyyy).  When I import

How do I export data to a text file using the transfertext command and having
the data be comma delimited with no quotes?
I can export comma delimited with and without quotes using the Export
wizard. How could I automate these two exports? Are there other methods?

I tried to import a file with Access, clicked on File Type to put it on "All
Files" like I do every week for reports, but this time it was not there.  How
do I get it back?  Or how do you import a .dat file without it?

Access XP and Office XP Object Library
Below is the code I am currently using to use fileDialog to open the dialog
from Access from a command button.   The dialog open nicely and I can select
from many files based on my initialfilename.  

A user of mine recently got a new machine (with an upgrade to Access 2003
from 2000).  He's going through his usual import procedure (File >> Get
External Data >> Import).  He drills down on the spreadsheets he wants to
import, clicks Import and gets a message saying:

I'm trying to export an access file to a cd and access wont let b/c it's a
"read only" folder.  I've checked and none of the read only boxes are marked.
Appreciate any help.  Thanks

I structured a table with 56 fields. The total characters for these 56 fields
is 566. There are 2,923,797 records in the text file. When I attempt to
import into the existing table, I get an *Invalid Argument* error message.
The *.mdb filesize (using MS-Explorer) becomes 2,095 ...

I cannot publish in Word or analyse in Excel (from Tools) once I have put the
datbase on another PC.  
Can anybody help me with this PLEASE.  I have designed lots of datbases for
people but they need to publish in Word.

I'm doing some automation to Excel from Access with the following.
This code fails exactly every other time I run it and works fine every other
time.
Dim objExcelApp As Object              'late binding

Our Largest software vendor has used MDB files to store data for their
application. We have used this by attaching to those files with Access to
run custom reports. They are going to upgrade their data to SQL server next
month. Will I still be able to attach to SQL server tables? ...

All of a sudden, I am unable to Get External Data from a csv file.  I have
been importing just fine for weeks, but this morning when I try to Get
External Data and select my file, I get a form titled mx_FrmMain that doesn't
show any of the data, and neither the Next or Cancel ...

Transferspreadsheet when exporting to Excel doesn't really seem to be a good
function to use when exporting to Excel.
1. I am using a template with formatting, first sheet gets bypassed beacuae
a new sheet gets created.

I have an access 2000 database (with the adp extension, so it's actually a
SQL database) and I'm am trying to "append" data from a view to a table.  
Both have the same number of fields, each are the same field types, however
the following Procedure says bad things about the proc ...

I am trying to export data from Access to Word using Word Mail Merge.  So
far I have been successful exporting an entire query to one document or to
multiple documents with different filenames, but all documents contain all of
the data that I am exporting.  This is what I would ...