In Access 2003 I have a template worksheet which I import into an existing
access table using the Wizard. Normally, I highlight the file and check that
the first row are data labels then import or append the new data. Using the
same template, I have tried to append the same data ...

Is there a way to export a table as a DB2 table?

When I import data from a csv flat file to access, the memo datatype columns
are truncated at 255. I found a lot of information about various operations
on the data that result in trucating it, but I can't even get the data in.
The source data is in csv, and I created the table ...

We have a number of Excell worksheets that are used to bid and estimate work.
To date, I have been updating these using queries from Access.  We are
evaluating Office 2007 and the major issue with Access is that the attached
worksheets are not updateable from within Access ...

I have 2 surveys on the same wss 2.0 site.  I am linking these 2 surveys as
tables in Access 2003.  I am able to access both linked tables as expected on
my primary machine.  On another machine with my same user account I am unable
to access one of the linked tables.  Other users ...

I must export 130+ data tables to Excel...and those data tables are in an
(one single) Access database as separate, unrelated tables.  The Access
database appears to be an Access 2000 creation.  
Trust me....there are NO relationships.  It is as if someone created

I need to import specific columns (A through G) from Excel; however, the
input files (excel) Does not have a constant number of columns.  I only need
the first 8 columns. The Excel file has a header row and the column names are
known.  Alternatively, I can name the 8 columns that ...

I am using DoCmd.TransferSpreadsheet to move a file into Excel from Access.
This will be done daily so the date must be associated with the file name.
Each time I compile the module, I get a CONSTANT EXPRESSION REQUIRED error.
This is the output line:

I have two queries
query 1.
ProjID
TaskID

I am creating a database with weekly staff hours in a format of 40:00:00, I
figured out how to get access to accept these numbers but now I need to
transfer this data accross to a crystal report to help compile it all.  I
believe their may be a setting in Access to allow this ...