Cant export query to csv
Wed, 22 Oct 2008 08:43:02 -0700
Hi,
Query below is producing "expected" result but when I try to export result
to a csv file, the export option in file menu is disabled, at the same time
if I dont use format in the date part export is fine. The date has to be
formated to be used in updating another database to be precise a mysql
database
...
|
Link to Exchange Sever Address list in Access 2007 not working
Wed, 22 Oct 2008 07:49:00 -0700
When we establish a link from External Data\Import\More\Outlook Folder to the
Global Address List the linked table seems to contain records, but no data is
shown. Importing does not work at all, get error: "Method 'Value' of object
'Field2' failed. "
Links established in previous versions of Office also sh ...
|
Export 3 tables to the same Excel file
Wed, 22 Oct 2008 07:26:14 -0700
Hi:
I have amcro that transfers 3 tables to the same Excel file; the table
names are F1, F2, F3; I have prenamed the Excel sheets F1, F2, F3.
The problem is that there is no overwrite to the previous sheets; when the
number of records is less, it transfers but the extra records from the
previous export ...
|
importing MULTIPLE excel files simultaneously
Wed, 22 Oct 2008 06:09:01 -0700
Is there a way to import multiple excel files into an access database
SIMULTANEOUSLY, or do the excel files have to be imported one by one? All
files have identical column names.
Thanks
--
William ...
|
Import Signed Numeric data
Wed, 22 Oct 2008 05:35:00 -0700
I need to import a text file into Access. One of the fields contained in the
text file is in Signed Numeric format, which I need to convert to a numeric
value in Access.
For example, 6705N in the text file should convert to -670.55 in Access.
--
ZSauce ...
|
Error in opening paradox database(Incorrect collating sequence) RS
Wed, 22 Oct 2008 05:00:01 -0700
I have a paradox database backups which I used to open with ms access. And
after i formatted my system and tried to open the same files i get error
saying Incorrect Collating Sequence.
What am i missing? Do I need to upate any driver or I need to update paradox
driver?
I tried lots of things but am not g ...
|
money 2005 software
Tue, 21 Oct 2008 08:41:01 -0700
will Microsoft Office Accounting Express 2008 run money 2005 software ...
|
|
|
Exporting a report to Excel and/or Word
Tue, 21 Oct 2008 08:31:02 -0700
I have a current report that when I export to excel or word the current
formatting is not the same as the report. Is there anything I can do to
correct that?
Thanks in advance ...
|
import dbf tables
Tue, 21 Oct 2008 07:54:00 -0700
hi,
i am trying to import a dbf table from alpha 5. most tables will import ok,
but some tables i am getting an error which says 'search key can not be
found'.
does anyone what the cause might be.
there seems to be no difference in the tables being imported, they all have
an id field which is the sam ...
|
'<linked table name> isn't an index in this table' error in access 97
database
Mon, 20 Oct 2008 20:57:14 -0700 (PDT)
We've got a weird one. A client had his system lockup when he forcibly
rebooted it, he tried to open up their database which has the front
end DB on each of their PCs and the back end on the server.When most
of the users start the database it starts as it should and operates
just fine. When this user opens the d ...
|