I have an Excel workbook with multiple sheets (22) that I would like to
import into Access Tables for manipulation.  I'd like to load them all to the
same table if possible, so long as I know what the name of the sheet the
records came from.

I have developed an application on MS-Access and I want to expand its
functionality the following ways:
1. As number of transactions increases, I am afraid that MS-Access may not
be able to handle it in the future. So I want to split out the data to some

I accidently deleted a table from a database file.  Fortunately, this
database had ben saved to DVD.  When I tried to copy the table from the DVD
unto the database on my hard drive, the paste option was not available.  I
found it impossible to past to the desktop or the database ...

This is a follow-up of my post dated 25/12/2004.
Can someone tell me a way of counting the number of records stored in a text
file. The records in the text file are stored in the following manner:
1. Code_no:    10 character.

Good morning everyone!
I have the following situation in an application:
For security reasons, linked tables are created at startup of the
application (tabledef is created in the Access DB and then linked following

I have a text file that I import into a table named new data. At this time it
takes the user thru 6 steps with the wizard. I would like to have it set up
so that the user would just need to click a cmd_btn and the import dialog box
comes up with the file type set to txt. Then ...

I have an Access 2000 Application that has about 50 relational tables.  This
application contains a subset of records that were exported for me from
another location's application.
I have since made numerous changes to the subset data as well as adding

Our company standard is Access 97. The version that I am running does not
allow me to Import/Export Excel files. Any ideas how I can fix this problem?

Situation: W2k Svr SP4 with T(erminal)S(ervices), Citrix, Office XP Pro.
Prob: When importing an excel file, and you reach the "field options"
screen, you only can change the properties of the first column.  When you
select another column, nothing happens.  So only the first ...

I know that this is a common question and it always gets the same answer, but
it won't work in my situation. I have one of those situations where, when
linking a table from Excell, it calls a text field as numbers. I am currently
the only user who needs to do this, but we want to ...

I have a couple of Access databases that contain several linked tables
referring to tables on a SQL server.   These linked tables appear to have
"DSNless" connections which is exactly how I want them.  The problem is that
I need to add a few more linked tables in this manner and I ...

I want to import certain lines of data from an ini text
file and insert it into a form text box.
eg Entry in ini file is "ArchiveDir=c:\archive". How can
I search this file and insert "c:\archive" in thetext box

I have a need to export a table to some of my remote
users who will then need to import
the data to update their database. I presumed to use the
following:

I am looking for a way to build my parts list for multiple vendors in Access,
and then from an Excel spreadsheet perform a lookup of a piece of that data.  
Basically in Excel I want to type in a part number, and have the next 4
columns return description, vendor, list price and ...

I would like to import into Access 2003 a dbf file that was created in
Microsoft Works.  After reading the Office Assistant in Access, I should be
able to select FILE, GET EXTERNAL DATA but it is greyed out.  The Office
Assistant also talks about obtaining ISAM BDE Drivers.  Does ...