I am trying to pull specific information from an access database into certain
specific cells in an excel sheet.  For instance, an employee fills out an
access form with date and time, etc. and this info is then exported to an
excel file that displays all of the info in a ...

I am impoting a excel spreadsheet into my access database as a new table.  I
am getting an import error message.....type conversion failure....the fields
that are failing are numeric values.  I've tried changing them to text and
number on the spreadsheet for iomporting and it ...

In a macro I am doing a TransferText Action.  The Transfer Type is fixed
width, and I am using a Specification Name argument as required.
I am getting the following error:  The data being exported does not match
the format described in the Schema.ini file.

I have a problem in that if i use the following expression to export data:
DoCmd.TransferText acExportDelim, "BKALLEXPT", "BACKLOADALL", "\AT2000\
EXPORT.DAT"
I get an error which says "cannot update. Database or object is read only"

I'm trying to create a database in which there is only one table that
contains all of the payables for a company. All the payable invoices have
primarily 3 fields: 'type of cost', 'date due' and 'amount'. The object of
the database is to obtain a printout of expenses categorized by ...

I am writing a database application, my working database name is "myDB.mdb".
I am trying to write some sql code in a model to import data from another
database,
How can I make my code below works?

I have a txt file with all info in one collumn. Data is seperated by ":".
How do I convert them into collumns so that I can import them to access?
Company: Dufwa Design
Date : 15-10-2004

The following method would not work until I changed the file type to .TXT. A
message appeared saying (I think) "Cannot import this file."
DoCmd.TransferText acImportFixed, "Transaction Import", "tblMyTable",
"G:\MyFolder\01202005.TRX"

I'm using Ken Getz' API call from http://www.mvps.org/access/api/api0001.htm 
and I was wondering if it is possible to have this chose just the directory,
and not the file name.  In other words, I want to export a few reports to RTF
files with set file names.  I just want user ...

My table has numeric field, defined as double, fixed decimal, 4 positions.  
When I export it truncates to 2 decimal precision.  How can I get around this?

I have a text file importing from 400 query that has 10 different date and
time columns that require calculations.  This is presently in an Excel file
but I need to move to an Access database.  I can pull it from Excel to Access
with no problem but need to pull the text file ...

I need to export data from Access to Excel usign Vb code. So I would like to
get the code to make this because I don't have time to investigate and I have
to make it soon.
Thanks!.

I am writing code to automate the import of an excel spreadsheet.  However -
I have no way of predicting the spreadsheet location.  Is there a relatively
easy way to call the "Open File" dialog box, or such so I can have my user
provide the location of the file for my ...

I am finding it difficult to find a way to get an automated way of storing
the file name of an external document in an access table, does anyone know a
way to
find the file and then save it in a table record?

I need to import and export Japanese DBCS files in MS Access for data
manipulation.  User inteface is finein English.  
1) Is this possible?
2) If so, will I need to install the multi-lingual  package.