I recently discovered the means of importing text or spreadsheets thru the
help section but as mentioned in the help a Import Text Wizard has to open
as soon as the file which is being imported is chosen but this does not
happen in this case. After a while it just shows the import ...

I have a table with 3 fields. The primary key is the name
of a file (xxx.jpg).  I have been hand jamming the names
of the newly uploaded files everytime. The filenames are
linked to a directory of jpg's which are viewable in the

I have a VBA routine that uses the Excel object model to open a spreadsheet
and inputs data.  If I use the VBA code to close the file I'm OK.  When I
leave the file open to work on it outside of Access, then close it from
Excel, something is not completely closing.  If I try to run ...

I have an external link to a text file.  A date field is
in this format: 20040215
If during the link process I set the field as date/time, I
get an error in the resulting table, something like #num!

I keep getting an error message:  First row contains data
that can't be used for valid Access field names.  
The first row in my Excel document is the exact same field
names at in the Access table I'm trying to import into.  

I have a database that i enter client information.  i
recently received 2 disk with new client information, it
is well over 800 new clients, so i don't want to have to
manually enter these clients, the disk have access

How Do I export email adresses from Access to Outlook
Express?  I have queried my database table for First name,
last name and email adddress.  I want to put them in my
Outlook Express address book without entering each one.

I have 3 Access2K queries that I want to export to a
microsoft Excel File that has 3 worksheets. Each query
results in Access should be appended (No Overriding) to
one of the three worksheets.

What I would like to set up is a way to use data from an
excel spreadsheet to create a database of records.  The
excel spreadsheet changes each week and I want the Access
database to check the Excel spreadsheet and update the

I have used the common add/save dialog box to let a user find a file he wants to import, but I can't figure out how to let them just select a directory or a drive (like A: or B:) to import specific files from or export files to.  I don't want to use an input box, because it is ...

I have a datafield in Excel that is elapsed time (i.e.,
ranges from 00:00 - 59:59) and I want to import it into
Access 2000 and maintain the elapsed time format.  Access
converts an elapsed time value (18:28-18 min 28 sec) to a

I have an Access97 runtime application that I have distributed.  Some users cannot get past a TransferText command to copy table data to a floppy as txt files.  It doesn't seem to be consistent, so I am thinking that it may have something to do with their specific setup (???)
My ...

Importing Excel spreadsheet into an Access table.  After
import, a [Excel file name]$_ImportErrors table is
generated.  Table lists errors, field and row.  Error
is "Type Conversion Failure".  The entire column in the

I have a query that runs OK producing expected output.
But, when I Export it to Excel (or CSV) all I get is a file
with headings but nothing else. All other queries export
fine so it's not the environment. What may be the cause?

I use Access 2000 to connect and link to some tables in
SQL server 2000.
I have some reports in access2000 that display information
from these linked tables. There is no VBA programming here.