I need your help to make this import successuful.
I have arround 150 excel files that need to be imported into access.
The files are named "Report dd/mm/yyyy.xls"
The columns are Code-Name-Balance-Employee

I am trying to export or publish a report into word. The report has about 80
stores within it. Each store starts at a new page. Some stores have many
pages to them. I want to export the report out to word, but I want each store
to have it's onw location. For example: Laurel will ...

I'm trying to access data that resides in a .mdb that resides on an external
web server. I have the IP address and file name.
Something like http://123.45.67.8/folder/data.mdb
I have an Access 2003 application that I am running on my local and would

I have several percent-encoded text files I've loaded to my Access database.  
That's working well, but the data is percent-encoded.  I'd like to automate
the decoding of this data either on import or on command.  I've been unable
to find an easy way to do it.  I have no Access ...

Is there a way to call and use an online web service from Microsoft Office
Access 2003 or 2007?
If so, what are the steps?  If you will, please include a code sample of the
call.  Thank you for your help.

I am getting Error 3155- ODBC--insert on a linked table 'Order Entry ST
Material' Failed.
There are two tables I am popluating using DAO Addnew/Update methods.  On is
a Materials table the other a Tasks table.  The originating data is from

Hi All... (anybody?),
I have an application written in Access 2000 to import text files calling
the import wizard using vba
ie. Application.Run "AcWZLIB.mx_Entry", 1, str_SourceFile, "tbl_TextFile",

I am trying to import the data from an access 2007 database to create a visio
2007 Org chart.  I have done this with another file before so I know it
works.  Visio is asking for a .mdb file but the access file is .accbd.

Hi there,
I'm using Access 2003 and Word 2003 and I'm trying to import data from the
word form to multiple access tables in a one to many relationship, but I
can't seem to figure it out.

I am importing a text, tab delimited file into an access table using a File
Specification via the command. I am using Access 2007
DoCmd.TransferText acImportDelim, "myImport_Specification",  "tblDates",  
gstrImportFile

A MIS I am using exports tabular data as a csv file each night with
every field delimited with double quotes.
I need to link a table in my access database to this file to give an up
to date snapshot.

In Access 2003 I am exporting static form data as html for our website.  How
do I create an html template so I can change table properties, such as color,
font, etc?

I am using Access 2007 with Windows Vista. I am getting the following
compaction error after linking tables from another data base and performing a
compaction - repair:
ErrorCode -1002

I managed to create a visual basic module in access that will import form
fields from a protected word form into access.  When all of the fields are
filled out, it imports fine.  The only problem I'm having is that there are
several date fields in the form and if any of them are ...

The product spiff on Office Pro 2007 says that you can save contact records
created in Access to Outlook Contacts. I can't find any way to accomplish
that task. Any suggestions?