where to find Microsoft Jet.OLEDB.4.0?
Wed, 10 Sep 2008 21:19:01 -0700
I am working in a 2008 VB.NET application that is connecting to an Access
2007 database, the application is telling me that the Microsoft.Jet.OLEDB.4.0
provider is not registered in the local machine. ...
|
how do I link a table to a text file containing asian characters?
Wed, 10 Sep 2008 17:14:04 -0700
I have performed a data extract from our ERP ustilizing a report writer that
refreshes daily and saves the file as a text file to a local drive. I have
created a dbase that uses the "link table" command to the text file, however
- upon opening the file - the data gets cutoff at the first "special"
character ...
|
yes/no = true false when merged
Wed, 10 Sep 2008 09:01:01 -0700
I am trying to merge an access quary to a word document. The fields with the
check box come up as true/false. how do I get it to show yes/no. ...
|
ADD New Question
Tue, 9 Sep 2008 19:43:01 -0700
Just learning to use ADO. The code example below illustrates what I'd like to
do using ADO, though I'm not sure quite how to do it.
Dim db As DAO.Database
Dim rs As DAO.Recordset
Set db = CurrentDb
Set rs = db.OpenRecordset("tblMyTable", dbOpenDynaset)
rs.AddNew
rs!MyField1= Me.Fiel ...
|
importing from Excel
Mon, 8 Sep 2008 19:55:06 -0700
I am trying to import a table to a new table in Access. I get the finish
butotn in the wizard, and get an error. All it says is "An error occurred
when trying to import file ....The file was not Imported."
I checked the cell type in my Excel spreadsheet. I eliminated all odd empty
boxes. I scratched my ...
|
Importing Fixed Length File into Access 2007
Mon, 8 Sep 2008 11:47:02 -0700
I initially attempted to import the MS Access 2003 database to 2007. It
appears that the export was successful. However, when I attempt to export a
fixed length flat file, and using the saved import spec, I get a xml error
(The specification XML failed to validate against the schema. There is an
error in t ...
|
Import Transformation of Data Tables
Fri, 5 Sep 2008 13:58:04 -0700
There was a thread back at 10/15/07 that addressed this but the solution
required PERL which i'm not familiar. I have a large table in excel with
many columns. I want to bring it into Access as a table wtih many many rows
and only 3 columns. Basically trying to convert a crosstab into a simple
database. ...
|
|
|
I need help on Transfers accounts receivable data to Quickbook
Fri, 5 Sep 2008 10:23:02 -0700
I have a report generated from MS Access which contains a list of clients
that paid money in one day. The report contains the following info:
Field Name Description
Chk Check or Credit number
Method Method of Payment
Account_ID Uniq ...
|
Re: Export Data in Access Table to Mulitple Excel Files
Fri, 5 Sep 2008 08:21:02 -0700
Thanks for the post - it has been very helpful. I was hoping you could help
me with one issue I am having. I get the same error a lot here is what is
says:
Microsoft Access was unable to append all the data to the table
The contents of fields in "X" records were deleted, and 0 records were lost
due to ke ...
|
Using LIKE Operator
Thu, 4 Sep 2008 22:06:00 -0700
Is the LIKE operator permitted in ADO. I get an Error 0 Operation Not
Supported in ODBC ... when I try to code a search string. The syntax works
for local database tables but fails when I try to pull records from unlinked
back end using ODBC connection string.
SELECT tblMyTable.* FROM tblMyTable WHERE (((tb ...
|
