Can anyone tell me how to import multiple files into an
Access 2000 db. I have over 100 files I need to import.  
Thanks.

How do I do this with out losing the orginal database to
corruption or errors.
I am using win2kPro want to migrate from other programings
access database that is dissimilar to combine with active

I am trying to convert an excel spreadsheet into a dbf
format.
When I tried this from excel (using Save AS), I found that
field contents and headers were being truncated, so

I am working on a project where I will get a daily export of data from a website into excel.  It's a full export every day with new records plus changing fields to existing records as the website is updated.  For example the status of a record could change from 'no business' to ...

I need to export data from an Access Report to an excell report.  I need it to stay formatted either by the report or go into a fixed Excell format which has fixed headers and footers and Titles.
Please advise.
Pat

I have a spreadsheet that I am trying to import into
excel but when I do a File, Get External Data, Import,
and find the file, nothing happens when I select it.
Can you help?

I have a series of access databases that reference a
common set of linked oracle tables via odbc. Copies of
these oracle tables are being migrated into sql server and
I want to update my links to reference the new sql server

I have posted the message below several times with no
responses.  Am I in the right place?  Can someone direct
me to where I should pose this question or is my
description laking.  Any help would be appreciated.

I have a one-to-many relationship between "Organizations" and "Projects".
The fields that further describe the organizations are stored on a main
form.   Then I have a subform (datasheet view) that holds information about
its subordinate projects.

Hi group,
I have a shortcut on my Desktop that opens my Accesss
file. I also have all my tables stored in SQL server and
MS Access runs the reports by getting data from my SQL

I have been using the following Docmd in access 97.
DoCmd.TransferSpreadsheet acImport, ,
strTableName, "c:\data\resources\" & strFileName, ,
strTabName

I have a large data base in Lotus.  I would like to
import the whole db into Access.  I frequently open an
individual file in Lotus and send it as an e-mail
attachment to business associates.  Fewer and fewer of

I have a database which i import text files into.  
Periodically the text file is updated and i need to re
import it but i get an error that says access was unable
to append the data and that 0 fields were deleted and 300

Can you tell me if there is a way to set up a vb script
or a macro to import a table from another database?
I am on holiday for 2 weeks and somebody to needs to run
off some reports.  Usually I import the table from the

This is what I want to accomplish:
I have a document in WordPerfect that needs to have
fields inserted from my Access database and be launch
from within Access. (Basically picture a Report but in