I am trying to convert a 150MB Access 97 to Access 07.  The DB was password
protected, but I had deleted the password.
It gives an error "DataBase is encoded.  Decode and try again", with no
options.

hi, i have a problem;
i have several thousands of ms word documents and i want to import
that data in access.
problem is that the data is in textboxes (all files have the same

I am trying to import an excel file into access. But I keep getting this
problem where I format a column in excel as text but when it gets into access
it is formatted as number and I loss some of the data in the process.
I need to know what I can do to force access to recognise ...

Not sure if this should be posted in Query questions or Import/Export.  Here
is the issue:
I have a manager who wants to see data in Excel, but doesn't understand the
65K limit.  I am currently querying data by state and exporting to Excel,

I reference an object (Monarch) to create a table that I then want to import
into my Access Database.  The file is outputted by default to a .xls
extension and Microsoft Excel 2.1 Worksheet (I am using Office 2003).  When
the below command runs, I receive an error indicating that ...

I am using the TransferText function with a specification name to link/import
a large textfile.  Sometimes a primary ID is attached to the resulting
database; sometimes, it isn't.  How can I get it to always (or never) attach
the primary ID?

I have created a link using ODBC to a read-only table and I want to produce a
table from it.
I have a few requirements that need to be met.
1. Reduce the ODBC Table to only records Equal/Greater to 01/01/07

I need to export a report in Access 2007 to a pdf file. I know this is
supported but how does one specify parameters for the report to export? There
is no where clause in the output to method and I want to export this without
actually opening the report.

I am working on an application in which I need to import data from excel
files. I am working with approximately 4 different strucures of data in the
excel files.  I am new to using schemas but unerstand the concept.  However,
as i understand you can only have 1 schema file and it ...

when i export data to microsoft word date is exchange from dd.mm.yy to mm.dd.yy

I am using the DoCmd.TransferSpreadsheet to transfer the result of a query
into excel. Is there a way to get the results being transfered from this
query to be inserted into specific fields of a worksheet in the workbook I
have listed in the DoCmd.TransferSpreadsheet statement. ...

 I want to pull data from more then one field ( as it seems with a combo
box with multiple fields listed in a row ) and have it save these fields to a
diffrent table. What  I'm trying to do is take a Whole record and save that
record to a new table.

I am trying to import data from a .csv file using the “transfertext” command
in a macro.  The data is to be transferred into a previously designed table
with the data types predetermined.  Unfortunately Access insists on reviewing
the data on import and rejecting the data it ...

Is it possible to link query from other MDB database?
I would like to retrieve data from other MDB, it seems I need links to the
table and have a local query to retrieve data.
It will be nice to link a query from other MDB instead of link the table.

Hi how do you export a Access 2003 report to Excel 2003 using code?
I want to export the report after it has been previewed because date is
updated as and when it opens.
So I want to open the report then send it straight to Excel using code.