I keep trying to import a dBase III file into Access 2003,
and I get "access was not able to perform this operation
because the project is not connected to a SQL server
database".  I am not using a SQL server -- how do I

Can anyone help me with this one?  When I attempt to reimport an Excel file, I get the error "Error occurred trying to import file 'XYZ'.  The file was not imported."  This is what happens:  I import the Excel file the first time, creating a new table, with no problem.  I then go ...

I have a macro that imports a few text files. I check for
the existence of the text files with a Dir function.
Now whenever I call the dir function I get "The expression
you entered has a function name that Microsoft Access

Is there a way to import the contents of an entire
folder.  All files are excel and same format.  Is there a
way to set up a macro for transfer spreadsheet and write
something in the file name field like "C:\foldername\*.xls?

How can I place today's date in the file name of a
TransferText command in a Macro. I want each daily file
extract to have its own unique name and not write over
previous day.

I have a report in an access 97 database that has a 300
page report. Each page needs to be emailed to the
corresponding employee, if that employee has an email
address. If he does not, then it needs to be printed.

I need to import data from a Excel file into Access Table.
A column in Excel file is empty and then imported into
Access Table it default becomes interpreted as NULL.
Any suggestion to get the imported field into Empty String

Our IT department delivers a floppy disk with a report
that we would like to import into our Access database. I
set up the import process as such:
1. Rename file to xxx.txt

I would like to run a query each month to get a list of
past due 8-Ds.  Easy enough.  But, I would like to send
the query results to each team member with a past due
8-D and a message   "Please follow-up".  Can this be done?

Error says Field 'F1' does not exist in destination table
'Drainage & Utilities'.
Here's what I'm doing:
In Excel VBA I make an ADO connection and then I create

Hai All,
can any one help me in the following issue?
I have foxpro files of format .DBF & .FPT
I want to export this Foxpro Table to access table.

I have upsized my application front end and back end from
Office 97 to Office 2003. The upsize went fine. I made
some changes to the application. The replicated back end
changed location. I went to the Licked Table Manager to

I have created an ODBC link to a Maximizer Table, when I
then try to select the table through File - Get External
Data-Link Tables-ODBC databases as list of available
tables appear, I select one then click Ok I then get an

I have moved a sql database that had tables that were
linked into an access database for reports.  How do I
change the links to look at the new database location.  I
have updated the odbc link.  Any help would be appreciated

I have an excel spreadsheet that has 15 or so fields that
i can import without a problem.  However the spreadsheet
has a heading at the top with various info about the
order.  Is there a way to have the heading be imported as