Access import not handling ALT+ENTER char from Excel
Thu, 25 Sep 2008 19:35:01 -0700
I am posting this as a new question, although it appeared on this site four
years ago. I was excited to see my exact problem posed as a question then,
but the end of the thread isn't quite what I'm looking for.
Alt-Enters in the middle of an Excel cell are being read by MS Access as an
end-of-record marker. ...
|
Why does TransferText trim when importing string
Thu, 25 Sep 2008 13:33:02 -0700
I'm using the following line to import a text delimited file :
DoCmd.TransferText acImportDelim, "MySpec", "MyTable", "D:\Export\File.txt",
False
One of the fields in the file has names that have extra spaces at the end.
For example: "Company","John Doe "
After the import, the table contains "John Doe" ...
|
Import dates in access database into outlook calendar
Thu, 25 Sep 2008 12:33:07 -0700
Does anyone know how to import due dates listed in Access into an outlook
calendar?
--
Lea ...
|
Access: Memo Fields Being Cutoff When Exporting Reports into Rich
Thu, 25 Sep 2008 08:43:01 -0700
Software: Access 2003
Problem: We export Access reports in Rich Text Format (.rft) using the
"OutputTo" command shown below. It works fine except the memo fields get
truncated sporadically (i.e., not all of them and not every time; seems to be
based on the amount of characters). I have read several thread ...
|
email
Thu, 25 Sep 2008 05:22:01 -0700
I have figured out how to email an object (report) as an attachment, but I am
wondering if it is possible to send query results in the message body.
We do a daily email to our members and the information sent is queried in
our database and then from the report I have to retype everything. The
"powers that ...
|
Re: Access import not handling ALT+ENTER char from Excel
Wed, 24 Sep 2008 21:02:00 -0700
I would love to reopen this four-year-old issue, as it's been plaguing me for
a while now. I came to this forum and was excited to see my exact problem
captured in the subject header, but the end of the thread isn't quite what
I'm looking for.
Alt-Enters in the middle of an Excel cell are read by MS Access ...
|
Import xls data into table
Wed, 24 Sep 2008 15:16:01 -0700
I am using Access & Excel 2000, and cannot get this command to create and
load CheckLoadTemp table. I created a form with a button that points to this
code, but when I click the button, nothing happens. Please help.
Private Sub cmdImport_Click()
DoCmd.TransferSpreadsheet acImport, 8, "CheckLoadTe ...
|
|
|
Cannot delete spreadsheet cells ERROR
Wed, 24 Sep 2008 13:05:06 -0700
Has anyone ever gotten this message? I was trying to run a Macro to
automatically update a spreadsheet within Excel and got the "Cannot delete
spreadsheet cells" error. I had to go into the spreadsheet and delete the
contents that was previously exported. Does anyone know why the data could
not be overwritte ...
|
Exporting Dates problem
Wed, 24 Sep 2008 11:10:01 -0700
I am trying to export a date column (and others) in a table to the
dd-mmm-yyyy format. When I use the Format function in a Make Table query,
the subsequent wizard option to 'Save Format' is checked and grayed out.
The resulting txt file shows the correct format for the date but contains
other formatting I ...
|
Import/Export Question
Wed, 24 Sep 2008 06:23:01 -0700
Hello,
I am trying to help someone in another area to use information from an
access table that is received by a vendor and dump it into an excel
spreadsheet. I need help in either doing this another way or help with coding
to make this work and any and all ideas and suggestions are welcomed!!
1. I was g ...
|
