Importing Problem when importing a table
Thu, 11 Sep 2008 13:58:06 -0700
I have a database that I import tables into. I have had no problems
importing Excel spreadsheets into these tables in the past. However, we are
training people from Argentina to do this same process in their office. They
use the same database and the same Excel spreadsheet and when they try to
import the ...
|
Importing text file
Thu, 11 Sep 2008 11:02:03 -0700
I would like to import a fixed-width text file into an all-text table.
I already have a table with the correct text field sizes, but of course when
I run the Get External Data>import function, I am presented with a field
list, with field types and sizes which represents Access's best guess as to
what the tabl ...
|
need large message in Message Text of send object
Wed, 10 Sep 2008 23:41:01 -0700
Hi All
I want to use SendObject to send an instruction message to contractors. The
form contains all the info I need to include in the email, but I want to have
more than a one line email.
How can I put a full message in that field? I want to have proper parragraph
spacing in with the form fields in the ...
|
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. ...
|
