Dear sir
I receive a CSV file from my bank everyday, and I need to import it into a
table (names "TEMP TABLE", for example) in my Access 2000 database.
How should I write a macro/module so that Access firstly asks me to specify

I have a text file with 500,000 numbers in it on different lines
I need it sorted in ascending order.
I imported into a clean database making a table with 1 field an no index.
Then I sorted the table in ascending order, proved it by opening the table

OS: XP Home, Access: 2003Pro
Okay, here's an oddity . . .
Two databases, each with identical tables (TDFs). Data stored in the
tables is split across the 2 DBs, so half of the data is stored in the

Is there an easy way to use the data fields from an Access 2003 database to
send emails using Outlook 2003 to every email address in the database using
the data from each entry?

How can I replace a table in db2 with a table in current db?  CopyObject will
do it, but it won't replace--just appends a number and adds a new one.  I
can't figure out how to "replace" in the other db.  Thanks for any help.

I have 480 tables that have to be combined into one.  Each table has a
different date.  I have perfected a Union Query which grabs one table and
puts the name of the table (10/1/04) in the Source field -
SELECT [ID #],[CENSUS],[ADM],[DISCH],"10/1/04" As Source

I have a table that has several different columns.  I also have another table
that has some of the same columns.  I want to merge or import the databases,
so they are together even if some columns are blank
for example

Is is possible to hard code the text qualifiers when exporting a file.  I
have a query that I'm trying to use to export a file.  I got tired of trying
to play with how things needed to be formatted and wanted to hard-code the
commas and double quotes.  The commas work just find, ...

I have imported an excel sheet of addresses/contacts into an Access database.
I want to add the data to an existing table that has many more fields than
the imported file. I only want to import the address information. I can't
seem to find an answer. Thanks!

How do I import from Excel each  row + the header row.  In other words, I
want each row of the Excel sheet to also have the header row.   The header
row is the only way i can identify the data.  I can clean it up later with
SQL..

Hi -
What is the best way to import a text file into an existing table in Access
2003 on a daily basis?  
Brief scenario:  This is for a research study.  Daily I get text files from

How do I export query results greater than the 65,000 excel limit?

Using the RunApp command in a macro, how do I set up the corresponding
command line to open Excel (I have that part: C:\Program Files\Microsoft
Office\Office10\excel.exe), but to automatically open a workbook named
Transfer_Log.xls.  I think I need a switch )e.g."/" but can't ...

I have done a query in which I combined two text fields and when I try to
export the data to Excel or Word it cuts the data off at 255 characters.  How
do I fix this?

I have a user who is importing Date time values via the wizard. Every row is
generating a 'type conversion failure'. The dates are in the form mm/dd/yyyy
hh:mm AM/PM. Can this be done, and if so, how?
Thanks.