The final hour is approaching quickly for me.  I have by Friday to make my
database live.  I will be starting a new job the following Monday, so the
deadline is absolute.  
I've never had to do this before, and I could really use some help!

Sorry for the cross post to odbcclientsvr, this looks like a better group.
I am using a DataDirect ODBC driver to link Clipper tables to an Access 2002
application. The linker selects a Decimal field size for Number data types.
Prior to upgrading to Access 2002 we used Access 97 and ...

I've set up a table structure and imported a text file in.
1 record is rejected due to primary key violations, but I don't seem to get
an Import Errors Table.
How do I get this? I've looked all through help and tools/options etc..

I have linked an excel spreedshet to Access. Everything works fine but
my question is:
Is there a way to change the data from Access? or its read only?
I want to be able to change my excel data from a form in Access, is

I have an "issues" application where tblIssues is essentially the main table.
The table is populated using frmIssues, which is based on a query which
allows me to display (in the form) certain values in drop down boxes by word
instead of the numerical values (autonumbers) that ...

I have researched this, tried the work-arounds, and still am unable to get
this to work.   Arrrrggg...
I am importing an excel file that has 2 fields that are numbers mostly (some
text) into a stage table with all fields as text.  When the import finishes,

Can I use a validation rule to set a mobile phone number for the UK as:-
+44 0
so that when a data entry is made, it automatically just appends the
typed numbers to this.  e.g   77123456  would read as +44 077123456

I'm having a problem trying to use transfer text in a macro.
I created a query.
I ran the export function to create the specification file.
The exported file was created successfully.

I work with 13 partners for 6 core clients. Each partner has a unique
reference with each client. I have a table with the headings partner /
client / referece. 78 entries in total. When I am preparing an invoice
I need to enter these details onto a form with separate fields for

Is there an easier way to set a Lookup function rather than having to
create a .csv or text file including " " around every item?
I wondered if I used a .csv in Excel and saved the file as a .csv it
might add commas which I could then replace with semi colons.

I want know that why there is NOT any relationship   between access and excel
and how I can sum and subtract 2 or 3 filds in access in any record
thanks
hadi_khodaparast@yahoo.com

is there a "simple" way to move a column of email addresses in a datasheet
in Access 2000 into a distribution list in Outlook 2000? thanks much, it's
for a noble cause - keeping health researchers connected!

I am currently setting up a database with a bunch of Excel reports from it. I
have to set this up on my own network and then transfer it to another network
(for our sister company).
It was suggested that i set up a file dsn on my network to the database etc

How do I automate exporting a form to a specified file?

I have a routine that ultimately results in a query being sent to an
Excel spreadsheet.
How can I, from Access, turn on "autofilter" for that spreadsheet so the
 Excel challenged user does not have to?