I have created my new database. I am using email to import information from
my customers so I can keep better track of items I get in for
repairs/replacement.
The email part is working but does not look good.

I know there has to be an easy answer for this but I just couldn't find it.  
I need to automate the generation of a report.  The data that feeds this
report is a tab delimited text file file that has a file extension of .DFG.  
When I try to import it into access, I get a message ...

I want to import data from an Oracle database into Access, but I cannot find
a way of restricting what data I want to be returned to Access, ie a data
range of financial year paramater.   At the moment I get all seven financial
years instead of just the one I need.   Any advice ...

I'm working on a split DB that allows some users to create personal queries.
We've established a convention of naming user created queries as "P_somename"
Currently, when I update to a new FE I manually import all of these P_
queries from the replaced version into the new version.  ...

I am stuck.  I have a large table of data in many columns and many rows.  I
want to bring it into Access as a table of many many rows and a few columns.  
Basically, converting a large crosstab back into a simple database.  How can
I do this in Access?  Thanks

I want to export 5 queries to 5 sheets within the same excel file. The
following command keeps overwriting the same excel file.
DoCmd.OutputTo acOutputQuery, "qry1", acFormatXLS,
"C:\LocalDB\ExcelExportName.xls", False

Can you please tell me how can I import an Excel file using a form where the
user can change the file name - the path(folder) is the same; so wehn
clicking a button, user get a msg. to change the file name; the path up to
file name, will be deafulted in a test box in the form?!

I could not find info in the Import/Export area of MS Access, does anyone
have a solution to this error?

At current I have a spreadsheet that is weekly produced, the content of this
spreadsheet is checked for errors etc, this is much easy and less manual to
do so through Access which I am starting to work towards.  
I am trying to automate the importing of teh spreadsheet to Access, ...

I am creating the following sample form called "Apples."
File Name = Iloveapples
apple 1 = excellent
apple 2 = good

I was exporting an access database to a text file so i could use with a
varialbe date program. When I exported the database all 6's changed to 2's. I
have tried to repeat this but it has not happened again. This has caused my
company to lose a valued customer. I'm looking for any ...

Using 20000 I have a CSV file that has a field with the following format:
 10/3/2007 12:00:00 AM
When I try to import the data (File/Get Data/Import) and let Access assign
the type Date/Time to the field - I get Type Conversion Failure errors and

I have created an Access database with linked reports.  I need to use these
reports both format wise as well as to produce graphs from in Excel.  As the
people who will be using this information are not tech savvy I am trying to
automate the process as much as possible.  I ...

I have a table (or a report) in Access from which I would like to export data
into an Excel workbook.
There is a field I would like to use as a group header and would like each
group to be exported to an individual worksheet within the workbook.  Is this

I need to export my data in a very strict text format like this:
First name: 15 characters
Last name: 20 characters
Street: 20 characters