I am trying to export a report in Access 2003 to Excel. Every record that has
a number and an 'A' at the end, changes to a number in Excel. For example
In Access   In Excel
 2A              .083333

Here is what I need to do, just need to tie it all in with VBA for Excel
from within Access
I export my data into an excel spreadsheet, autofilter and arranfge column
widths, then e-mail to an exchange folder, all from VBA

Is there any way, either using the TransferSpreadsheet action or VBA, to
transfer a table to an Excel spreadsheet WITHOUT the field names transferring
to the spreadsheet as well?
Your help is greatly appreciated.

When I import a spreadsheet from Excel I try to modify the Fields on Field
Option, but I can't select the field (column), This is happening on the
"Import Spreadsheet Wizard" dialog box

Hello and Thanks for reading my issue.
I have 7 PDF files, I don't really care if they stay as PDF's but I would
like to link a button to open the Exteranal form at a specific location with
the use of a push button???  Does that make sense???

I am using vba to redefine the rowsource of a listbox on the form as the user
selects specific criteria. My question is how can I export the results from a
list box to Excel? Has anyone done this before? Any pointers are very much
appreciated.

I'm a long-time user of Access 97.  I have just received Access 2003 and I
have a small issue with importing text files into new tables.   These are
Fixed Width files and I establish the appropriate break lines, then the next
step is where the issue resides   . . .   with the ...

When exporting from Access to a comma delimted file with text qualifiers as
set as quotations marks, the empty fields are not surrounded by the quotation
marks in the rsult export.txt file.  The odd thing is that in the export
wizard, the quotes surround the empty fields but in ...

Hi one and all.  I have a very specific problem.  How can I get a hyperlink,
and the text to show in the link – e.g. ‘click me’ – into a table
automatically?  I need to import and link 70,000+ files which will be subject
of database reports.  I can do this by having the text of ...

Using Access 2000 with WindowsXP
I am importing a text file using DoCmd.TransferText, is their way to have
access check to see if the file is there first?
I import four text files at a time and would like some kind of check to make

I imported a database from Microsoft Compatibility Analyzer into Access.  
When I open one of the tables, instead of getting useful numbers regarding
hard drive information, I get hexadecimals.  I have tried changing datatype
information but when I do, it deletes columns of ...

I am trying to set up a database from information stored in a Mac program
called "Entourage".  Does anyone know anything about this program and how to
import it into Access?

I am using Access 2003 and trying to link an excel table.  I keep getting
the message 'subscript out of range'.  I can't figure out what's wrong.
Any ideas?

I get every other line blank when importing a .txt file. If I let Access
assign key then the blank lines are numbered. Odd numbered lines have data.
Even numbered lines have no data. I can filter and delete them out but I use
a spec file to build the tables and I then run macros ...

I have created a Macro which exports the table to a specific location.
How can I get a promt to choose the location where I would like to export
the data to. Any one knows how to do this?