I recently used Excel to link an Access query as external data to an Excel
worksheet, then linked that file back to Access to use as a table.  To me,
this was a workaround way of having query results as a table.  I set the
Excel file up to auto-refresh every 60 minutes, but the ...

Just would like to know if it is possible to connect a FE database to a BE
on a remote server, if so, what connect would I use?
Thanks
Lez

The home office is trying to send me a DB file "CUST_2.mdb" and outlook will
not
pass it through. They are both written in Office Pro 2000. How do I open
this file?

I am importing a csv file and when I open the new table, all of the values
are enclosed in quotation marks.  How can I remove the quotation marks?  Or,
how can I get my query to work because right now I can't filter it.

i have 3 tables in excel that i need to import to access 2002.  The
three excel tables all have different information but they all have at
least two fields of information that are similar: serial number and
size.  This is what i need, only the two common fields for each of the

Hi Guys. I have created a standalone database for a client that is set up on
all their laptops. Their employees enter information onto the database on the
laptop and when they return to the office they sign off the information and
it transfers over the wireless network to the ...

how can I output a report to a PDF format?
Thanks for you help

I can across this, which seems to suggest it is possible to put data
into an Excel named range.  Requirement is named range must be more than
one cell.
http://alexdyb.blogspot.com/2006/07/export-to-excel-range.html

I am using Office 2007 for data collection with the new Access feature.  The
entire process works fine, but I am unable to collect the e-mail addresses of
the responders unless they key it into the form.  The survey is based on
tSurvey with the following fields:

I'm trying to import Excel 07 files into Access via the import wizard.  I
let Access add the primary key.   However when I open the file in design
view, no fields are selected as the primary key.  In addition, in Query
design, no relationships are established.  What happened?

Hello and Greetings from upstate NY
Help Please,
I am about to build a new relational dBase and want to know how do import
the old dBase that has been collected over the years.  This project  is for a

This  project exports data from Quickbooks and formats them in Access to send
a text file to a warehouse.  The data contain customer and order detail
information, whereby one customer can have more than one item on order.  I
can create a report that does summarize the detail ...

Is there a way to check using SQL in VB that a Table exists, when you know
what the table name is?
I need some sample syntax: The following Syntax will give you an idead of
what I am looking for...... this is incorrect by the way......

I am upsizing an Access database to SQL server 2000 and have
encountered a problem when attempting to add new data, or edit
exisitng data using an Access Form.
I have upsized, and checked all functionallity on the Access database,

Okay, I imported successfully last month to an existing table.   This month,
problems.   I made my file a txt file, and through this found that I had a
extra column in my file.  Fixed it and now I am getting the error:
ORA-01013: user requested cancel of current operation.