I have a MS access database into which I need to import a text file
that is oriented vertically (fields are listed from top to bottom with
the value for each field appearing to the right of the field name (with
a "|" as a delimiter)).  The text file will only have 1 record's data.

I have a MS access database table for which I regularly need to import
fixed width text data. At present I have to to cut and paste the text
data from its source to a text file, save the file, import the text
file as fixed width text [it is not naturally delimited], and then run

I have a table with an Item# field and a cost field.
For any given Item# there could several records with different costs.
How do I export or build a table that would extract only the lowest cost for
any one Item#.

I am trying to export a table to a .csv, csv does not appear as one of my
options as I am going through the export wizard.

Hi there!  Using A02 on XP.  Have a macro to export data to Excel 5-7 with
TransferSpreadsheet and named a query in the Table Name action argument.  
Worked the first time but now it says the table already exists.  My file name
is good and I'm not using range.  Of course the query ...

I am in need of some help.  I have a database that I created years ago in
access 2000.  I was using a field with people whole names were in a single
field separated by a single space. e.g. ("Halle Berry").  I am now trying to
split this field up into two fields one being [Last ...

In my database, I have created an option using the Shell command to open an
external document using a specific program.  I am having trouble with my next
step, in that, if a partcular computer user doesn't have that program, a
"Browse to" window will open, in which a user can ...

Is it possible to create a macro in access to get an excel file and
loaded automatically to specific table?
I understand the I can use the export/import access wizard but would
like to automate the process.

Is it at all possible to designate which folder files are saved to when
exporting data to Word when using "Publish with Microsoft Word"?  I'd like to
be able to send all exported docs to the same place so that things stay
organized.  Thanks!

Hi,
I am a new user to Access.  I am using Access 2003.  I have a .txt file that
has several names of people all seperated for a ";(semicolon)".  I tried to
use Access to import the .txt file, but unfortunately all the names come out

I currently have an Access database set up with all our clients.  My boss
wants me to scan the 50 page contract for each client and insert it in the
form view so he can have easy access to the contract through the database.  
Is this possible?

The error messages I keep getting are:
Run Time Error: 3709 The Search key was not found in any record.
Run Time Error: 3001 Invalid Arugement
Thanks!!

I'm trying to import a Tab separated values file in to a table.  Funny thing
is it worked for a while then just stopped giving the following errors.  I
have regenerated the text/data files and still no joy.  I did copy the code
to a new data base and recreated the form and table ...

Sometime ago I built a database which uses an EXCEL spreadsheet for one of
the tables through the Link Table command.  For the last year or so
everything has worked fine but now the spreadsheet has exceeded 16,383 rows.
The ACCESS table will not read any rows beyond row 16,383.  The ...

Hi,
I am new to Access.  I have a table in Access that I want fill with names of
people only from the Outlook address book.  I am not interested in the phone
numbers, addresses etc for each name, just interested in the name.  Instead