Migrating Paradox to MS Access Borland Paradox database to MS Acce
Wed, 27 Aug 2008 23:10:01 -0700
I need help Migrating Paradox to MS Access
...
|
Get External Data wants VBA Password
Wed, 27 Aug 2008 15:10:19 -0700
I have a db that I made some changes to (added a form and updated another).
I now want to update the db to my users. I thought I would be able to just
open the other db and use "File","Get External Data", "Import" to add the
three forms to the other databases, but I get an error message saying:
"Microso ...
|
Multiple excel files
Wed, 27 Aug 2008 15:07:16 -0700
I have multiple excel files in the same format, just different names that I
need to import into an Access table? How can accomplish this?
All the files are in the same directory. ...
|
Export Date without Time to text tab delimited file
Wed, 27 Aug 2008 09:24:00 -0700
I need to export a table to a tab delimited text file. I have a date field
in the file. I need it to export as just the date without the time. I have
an input mask of short date on the field, but it still exports with the time.
Currently exports as 8/26/2008 00:00:00... Need to export as 8/26/2008. ...
|
How to set filter for sync between access 2007 and sharepoint?
Tue, 26 Aug 2008 22:07:01 -0700
We build an environment between access 2007 and sharepoint 2007 through
linked tables, but some user only need to get his own data, we want set
filters for the linked tables, how to realize it? ...
|
Linking Excel sheet into Access
Tue, 26 Aug 2008 16:36:01 -0700
Hi there
I have linked an Excel 2003 sheet in as the primary Training Participant
data source to my Access 2003 database. All seemed to be working okay for a
while, but now the form we use to track attendance sometimes opens with
information displaying and sometimes does (the information is definitely in
t ...
|
check before import Excel file
Tue, 26 Aug 2008 16:28:01 -0700
I make it easy for users to import data from an Excel file to an Access
database by clicking a button on a form (in the database) that has this code
behind it:
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tblStatus",
importFile, True
I want to check the contents of a field in the Excel imp ...
|
|
|
importing an excel dowloaded worksheet to an access table
Tue, 26 Aug 2008 10:58:11 -0700
I am trying to import and excel worksheet that was downloaded from another
data source. when i go import, select the file and then access starts to
work but stops and indicates "there is no object in this control". I have
recopied the excel sheets and saved it as a CSV file but keep getting the
same messag ...
|
Export Access table to Excel that has more than 65000 records
Tue, 26 Aug 2008 05:55:01 -0700
Office 2007. I cannot seem to export an Access 2007 table into Excel 2007
that has more than 65,000+ records. It stops and gives me an error.
Shouldn't I be able to export all 95,000 rows in my Access 2007 table into
Excel 2007 with the new row limits? ...
|
Relative path to linked excel sheets
Tue, 26 Aug 2008 03:26:02 -0700
Hi together,
I have an Access DB File which is several linked excel sheets as data
sources. Currently the paths to these external linked data sources is
absolute. How can I establish a relative path, so that the Access file and
the Excel source data sheets are portable to others computers (e.g. via
e-mail ...
|
