I'm trying to export a table from Access into a text file. Everytime I export
the table, all the date fields that I exported have a time format in them.
How do I get the time not to export with the date fields? In the design view
of the table, all the date fields are Data/Type - ...

I cannot import a text file with extention .bcr. I do not want to rename the
file as it is created automatically from a third party system.
How do I add .bcr to the list of text files types?

When using Access 2000 to import data from paradox db, I
got error message says "Unexpected error from external
database driver(9737)". What is the problem and how to fix
it?

How do you launch a text file using a button in VBA?
I want to click on a button to open a log file - I would
actually like to open a dialog box that starts up in a
particular directory (eg C:\logfile) - the user can then

I have my main table in my database with the following fields:
Name; Status; ID etc etc
I produce an Excel Download from Business Objects to get this data and from
this i have 2 scenarios in which i was hoping could be automated?

Good Day,
 I am trying to create table that I import Excel Files into. I am assuming
that I will need a form to start the import process?
Can anyone help?

I wnat to automatically link a specified excel spreadsheet and not have the
first row be the field descriptions.  I have the automatic link part figured
out, but it always wants to take the first row as the field names.  If I use
the wizard, I can select not to use the first row ...

How do I import all my existing files from Incredimail to Outlook 2003?

Is their a way to copy Import/Export Specifications from one database to
another ?
Thank you,
Jeff

I have a table set up, and am trying to import data into it from MS EXCEl.
When I try to import the data into the table the only option that I have is
for a new table?
Any ideas?

Hello friends,
I am trying to import a lot of paradox files into a  ms access database, but
all the files have a length of  11 positions. Example: P2004-09-01.DB
I tried to import these files into an access database but it seems that it

I downloaded office 2003 trial which has expired and now I can not access my
files that I had in office 2002.  Obviously they were transfered to the 2003
edition.  How can I get them back?

Thanks to assistance, the auto import function works great ....... Now how do
I delete the source file from the C drive from within Access?  This is very
important to ensure that the user doesn't accumulate a bunch of csv files.

Dear Friends
I am using Micorsoft office Access 2003. I have two files master files where
i create all FORMS and i have user file which is used by users. I update the
form in Master files and then ask the users to import the same in their ADP

I have several database with identical fields that I want to make ino one
database, okay for duplicates.