My problem is trying to figure out if this can be done and if so code or
macro to run automatically daily.
I use 5 tables in a SQL database.  I can't link these table because when I
run my queries it slows down the entire system.  So to get around this I

Is there a way to trigger the import spreadsheet wizard in access 2003
with code?
Thanks.

I have a control on a form from which I'd like to give users a drop down
combo box so they can select and populate the field's data.  Ideally, the
drop down would contain records from an Excel spreadsheet.  Is this possible?
If so, how do I accomplish this?

How could it be set up to export from Access to Text file with desired
number of decimal places, say 6 decimals? Can Access 2000 do this?
It seems Access usually retains 2 decimals in exporting to text files.
Thanks a lot for your help in advance!

I've set up a Macro to Import a non-Access table into an Access table.
In the TransferDatabase macro...there is a field for the source table name.
I currently have the exact name of the source table..and it works fine.  
However, I'm needing to prompt the User for the name of the ...

I'm using Access 2000 (XP pro). I have a lot of reports that include graphics
(check boxes, text boxes etc) that don't export to Word. I'm trying to find a
way to send reports as email attachments to non-access users. Is there an
easy way to change the check boxes to Yes No & ...

Greetings all - I am in need of assistance and appreciate any guidance!
Two issues with one export file...
1) I am attempting to export data from Access 2000 query (data tables are
linked to SQL tables) - Export needs to be one .txt file, consisting of

My database has become corrupted. I'm trying to import all of the objects
into a new database. Everything imports fine except for one table. The error
dialog returns:
Invalid argument. (Error 3001)

I used
DoCmd.OutputTo acOutputServerView, "vewMyView", cFormatTXT, "C:\MyText.TXT"
to export a SQL 2000 view in my ADP.  
However I get a line of dashes "-------" seperating each row.

I'm trying to set up an automated way of setting appointments for a number of
people six weeks from their last visit.  I've set the date in a query, but I
was wondering whether anyone had been able to successfully export this info
to various calendars on Outlook?

I need to be able to invoke window's file directory system similar to the
GetOpenFilename method in Excel to allow my user to select which text file he
or sheet wishes to import into Access.   With the GetOpenFilename method in
Excel it takes only a few statments.  In searching ...

In ACCESS 2.0, I simply need to create a link to an SQL table.
I have access to the SQL tables and can open th SQL manager and browse them.
I've done lots of linking to dBase tables and Visual Foxpro tables via the
ODBC route...but cannot figure out the SQL link process just by ...

Have a function that checks for and open copy of Excel using
Set objXLS = GetObject(, "Excel.Application")
this works great if excel is open.  The problem is if the print preview is
open in Excel, Excel goes into a never ending loop with a error window

I want to export the data as text file but I want that only data should
trasfer and no spaces should transfer.Spaces  in fileds ( e.g. the field
length is 8characte and the data is 456 then it should be as 00000456) should
be replaces with zeros. This output file is required for ...

I want to be able to archive several tables from my database on a yearly
basis for all data from that year. (the year is recorded as a text file so i
can select rom a list  of academic years 05/06, 06/07 etc). The 2 tables i
want to archive are a "Training course" table and a ...