|
|
|
How to get from downloaded entries to email more efficiently
Thu, 3 Jul 2008 13:06:31 -0700 (PDT)
Each week our university library department gets a shipment of new
books from a distributor and we email ourselves (from their site) the
"short" form of their shipping list, then we manually edit out
numerous extraneous fields and empty space and email the resulting
list to reviewers. With usually a 100 or more ...
|
carriage return error when importing excel into access
Thu, 3 Jul 2008 12:36:35 -0700
I work with access and excell 2003. If cell in excell contains data as
follows:
Mary Smith
Long Beach
John James
Los Vegas
Then upon import or linking spreadsheet into access, a little square pops
in. This creates havoc in formatting, when I do a mailmerge between access
and Word.
I don't know prog ...
|
Why I can't export a text file, what's wrong here????
Thu, 3 Jul 2008 09:46:02 -0700
Hello.
I'm trying to export export a query result into a text file (not using a
link to a text file) and it's returning me an error message saying that it
cannot find the object.
I have this:
DoCmd.TransferText acExportDelim, "SupplierOrderHeader", "21",
("C:\Teste.txt")
And it returns me this error: ...
|
cannot uncheck "first row contains column headings" importing XL2
Thu, 3 Jul 2008 09:04:00 -0700
Access 2007, trying to import an Excel 2007 file. I am unable to uncheck the
bos FIRST ROW CONTAINS COLUMN HEADINGS. It does not matter if my data has
column headings or not, it ALWAYS puts the first row as the column headings.
I am unable to import the Excel file without adding a column headings row,
wh ...
|
Office 2007 couple export questions
Thu, 3 Jul 2008 07:07:01 -0700
I am attempting to supress two thing when running a macro to export a file to
the pc
1) The macro run an ODBC linked report and it prompts for a username &
password,
This used to happen once only on my original copy of office 2007, It seemed
to remember the username password box therefore not ask the user ...
|
Unique Identifier
Thu, 3 Jul 2008 06:40:02 -0700
Hi folks,
I'm not sure if this is the right category; I am linking a specific folder
from Outllook into Microsoft Access. The db I'm using is to keep track of
staff inquiries and I have linked a folder from Outllook to the db so that I
can keep notes on the inquires as they come in by e-mail. What I need ...
|
How do I move data in columns (XL) to rows in Access table
Thu, 3 Jul 2008 06:07:00 -0700
Hi
I have an Excel 2003 spreadsheet with columns-- Name, Date, Rating, Date1,
Rating1, Date2, Rating2, Date3,Rating3 -->etc up to -->Date7, Rating7.
In Access 2003 how can I import the above spreadsheet & end up with a table
with Name, Date, Rating - with the:
Date field of the table containing the dat ...
|
|
|
OutputTo Action in Query to export as an Excel file
Thu, 3 Jul 2008 06:01:01 -0700
Hi,
I am using a macro to access the OutputTo action that exports the results of
a query as an Excel file. The Output Format is Microsoft Excel 97-2003
(*.xls). After exporting the file I want to upload it to SharePoint, howerver
I receive a validation error when I try to do so. I found that if I open the
...
|
Creating an Import Spec รข?? Advance button missing?
Thu, 3 Jul 2008 04:20:00 -0700
I am using Access 2007 (SP1 MSO) and wish to create an Import Specification
for an Excel Spreadsheet so I may use a DoCmd.transfertext in my VB code.
However, when I start the Import Wizard under Create -> External Data ->
Excel, the Advance button does not show up; therefore, I am unable to Save
the impor ...
|
hhe
Thu, 3 Jul 2008 15:09:54 +0530
...
|
|
|
