I created a database in Access 2000 and was able to import data from an
excel file into an existing table without a problem.  We recently switched
over to Access 2003 and I tried to import an excel file which is set up
exactly like the previous excel file.  I received an error ...

I have several excel files (100+) with data I need to import into Access.
Each excel file has multiple sheets (4 to 6 sheets). I need to import data
from each sheet.
No blank sheets are included, and all sheets are formated the same.

I plan to have several csv files to import to access on a weekly basis. I am
having trouble figuring out how to do this efficiently.  A sample file format
is below. The text before the colon is the table name and there is more than
1 trainee per file. The csv file format is pre ...

I am importing data from an Excel table with 19,000 lines of dirty data. When
I imported the data into Access 2002, some of it was cleaned up, but rather
arbitrarily. I need to fix it all either before and/or after importing.
Examples:

I currently have an application that is developed in Microsoft Access 2000.
And I have an access backend. Now I want to know is it possible to use sql
server as a backend and what DB Connection Technology should I use. I have
done a bit of reading up on ado and access ADP.. What ...

It doesn't seem too hard to export data from Access to
Word, but it seems to be impossible to import data from
Word to Access.  Wondering if anyone can tell me how to do
this.  Thanks.

I am trying to export some of my data to Excel, but some of my text are being
cut at 255th char. The thing is: if I go to Excel I can put more than 255
char in one cell. Why can't I do it from Access? Is there a way?
Using: MS Access 2000, Excel 2000

I get the following error when exporting table/s from Microsoft Access97 from
my hardrive to another Access97 database on a network drive.  The first error
message box reads "Disk or Network Error", when I click OK another error
message box appears "Invalid Database Object ...

I am need of converting and Access mail database into an Excel file so I can
then upload that into a Quickbooks accounting database.

Can anyone tell me how I can import data from an old DOS Foxpro system into
Access 2003? The Foxpro system is still in use, so its data is changing and
this won't be a one-time import.
Thanks!

I want to export a large amount of data to Excel, but the standard export
utility in Access will only let me export 65K at a time. How do I do a full
export of a large table without having to split the data up into separate
exports?

I have been trying to work out how to do a mail merge using fields exported
from an Access database to Word. That bit worked. But does anyone know how to
remove 'duplicate' entries where a name might appear more than once in Access
but I wouldn't want to create a letter umpteen ...

I've asked so many questions of you kind people, but if I can get this to
work, my project is done!
I created a custom help file with the use of Shalom Help which was
recommended on this site. I thought that would be the hard part, but with

I have a text file that I need to import into my Access Database. The problem
is, this is the first report I have come across that has data for one patient
(I work in a hospital) spread over 5 rows. Example:
Name        Number      Location       Visit Date      Visit Time         ...

I need help unlock my documents so can help me.