I'm importing an Excel 2002 worksheet into an Access 2002
table using the menus.  The Excel spreadsheet has 4
columns all formatted as text, and one text column is all
numbers.  Access SHOULD import this as text and it does,

Does any one have a formula or a template for a purchase orde with auto
numbering ability ?

I have a spreadsheet with the following values in columns
A & B of the first 10 rows:
Col A   Col B
1       10001:ABC

I have developed a database for my church.  I also have a
copy of it at home.  I recently designed a new report at
home and would like to get it to the church's database.  I
don't want to copy the entire database because my data

I have 2 tables in Access. One of these is linked to an Excel worksheet. I
would like to create a form that shows information from the Access Table and
3 fields from the Linked Access Table.
Primary Key is StudID in the Access Table.

I'm trying to export a query into a text file but cannot
find the VBA parameters for exporting a tab delimited
file.  
This is what I have so far:

We have several computers, networked, pointing to the same database. In one
computer when I go to file/getexternal data/import , the dialogoue box does
not show excel files (drop down arrow). The rest of the computers are OK. Im
have reinstalled win98, access 97, but still the ...

I've created a database with Access 97 and had problems
with concurrency.  The database was upgraded to Access
2002 and since then we haven't connected concurrently.  
Does Access 2002 provide good concurrency protection?  

From Excel, get external data, new db query, when I select
a particular Access db on the network, I get the following
error "MsQuery has encountered a problem and needs to
close". If I copy the db to the harddrive, I do not get

Can import specifications be copied/pasted into a new
database, or exported somehow?

We have developed some import specifications locally and
are trying to transfer/copy them to the server version.  
We have used the import tool on the target database and
selected options and ticked the import/export

I'm attempting to do a rather simple system to link an
Access database to a word document as a mail merge but
I'm having a few problems. Basically I can only get so
far in linking the two and then it fails. It lets me

All,
I'm currently building a database to store information
regarding quality checks.  My QA dept uses an excel file
to "grade" work.  Once a grade has been completed, qa

I'm running the following code...
DoCmd.TransferText
acImportDelim, "", "tblTEST", "C:\data.csv", True.
The problem is 2 columns are being imported as "Currency"

When I use the RunApp command to start a Microsoft Word
Mail Merge a second copy of the Microsoft Access database
loads.  It remains open even after I close the Microsoft
Word Mail Merge document & application.