I am trying to import an EXCEL file into a new table and want to be able to
tell access which fields to index and which ones to ignore. However when I
get to the step where I sould be able to select field options as I move my
cursor/mouse over the field names the field name in ...

I and one of my clients are using Access 2003, and I have developed a
routine that successfully
imports an Excel spreadsheet that is generated from a Web site also using
Access 2003 into my Access database. Some of my clients are now using Office

Im trying to import from excel where i have a column having cumulative time
calculations. something like 35:12:36  expressing 35 hours and 12 minutes
etc... the problem is that i cannot find this format in access. where access
automatically converts this time to date\time. any ...

can anyone tell me the maximum record length of a table in access

I have a table that's sorted by an ID number field.  I need to export to a
text file in ascending order by ID number, but without the ID number
variable.  I tried saving the table correctly sorted and then removing the ID
number field, but as soon as I do that I lose the sort ...

I have an Access 2003 database the exports a report to Word 2003.  I just
learned that one PC is not exporting one of the labels fully. In the group
header there are 6 text controls that display summarized values.  Each has a
static corresponding label.  One label is suppose to ...

Hello i have an access database with a similar database with the sql server
and i want to exchange data with an existing  database in SQL Server 2005
how can this happen?
Thanks

This code seems to be looping through the same record over and over.  Any
idea what's wrong with it?
Function CopyRes()
 Dim db As Database

From Access, i need to access data colected in Excel, by linking.
Generally it works, but i cannot move excel table threw directories without
severing Accesses connection. I don't mind moving them together. If i could
make them work while in same directory it would be fine.

I need to import data from an excel sheet to a table in access. The excel
sheet may contain records that are already in the database. While importing,
the records that are already in the database must not be imported.
My database has two columns - Card number & Status

This doesn't happen all the time.  But, it happens enough to be annoying.  I
have to export two tables from a shared Access 2003 Database (Access 2000
format) to Excel.  I have a macro created using the OutputTo function that
places the spreadsheets in a folder on a local file ...

I would like to import my MS WORKS database file into Excell. Any
suggestions. Thanks in advance. Fran Meyers

I'm concerned about potential problems as a result of working with files
that have an additional "dot" in the file name; additional to the dot3 file
extension.
I will be working primarily with file types from Adobe Acrobat and MS Office

I am trying to export schedule information from an Access table to Outlook:
Tasks.
In Outlook: Import: ... Map fields: I mapped my employees name (Resource ID
- which I believe is a number but shows as a person's name on the screen) to

Trying to do what I thought was a simple task, import FoxPro table into MS
Access.
I keep getting an ODBC error: "You must install the current version of
Visual FoxPro ODBC Driver".