How do I export from Access to UTF-8 format?
Tue, 7 Oct 2008 06:55:00 -0700
I am trying to export Portuguese information into a text file. But I lose
some of the accented characters when I do because the info is being exported
to an ANSI file instead of a UTF-8 file. How can I fix this? ...
|
importing multiple worksheets from excel to access
Tue, 7 Oct 2008 06:35:00 -0700
Apologies for my lack of knowledge, Im a complete Access novice. I have
multiple copies of the same workbook in Excel, each workbook contains the
same table in the same range but has different values in the cells. I want to
automate an import in Access (transferspreadsheet???) that will automatically
import ...
|
RE: Inconsistant text length export to Excel 2003
Tue, 7 Oct 2008 05:23:00 -0700
This is a problem I encountered several years ago, and I found two ways to
work around it. There may be other ways as well,
1. Open Excel using automation, and fill the cells individually, one
record/field at a time. This method is a little cumbersome, and can take a
while if you are using a large query ...
|
Open Recordset with Parameter
Mon, 6 Oct 2008 10:59:02 -0700
I am trying to open a recordset but I am running into an error because the
query pulls a criteria from a form. The form is open when the code runs but I
still get the error "Missing Parameter" The code is attached below. I am
looking for assistance on passing the parameter to the recordset. Any help is
appre ...
|
How do I import a SharePoint calendar into Access 2007?
Mon, 6 Oct 2008 08:31:02 -0700
I want to import a SharePoint calendar in Access 2007 to build a dashboard. ...
|
Transposing Large Number of Names
Mon, 6 Oct 2008 08:14:06 -0700
Hey, I'm looking for an easier way to insert all the names on
http://www.asc41.com/director/frame.htm into a spreadsheet where everything
is transposed going horizontally with each of the address's and names and
departments and such falling into their own column with one name (address,
email, etc) in their o ...
|
Importing CSV files without CSV extensions
Sun, 5 Oct 2008 13:14:01 -0700
I have a collection of CSV files that are generated by another application
whose extension is a 3 digit store number (ex: E1003080.100). How can I get
Access to recognize these files as CSV or even Text in order to import them
into my Access database?
Thanks in advance...Carlos ...
|
|
|
How to test in Excel for exported Access table null cell?
Sun, 5 Oct 2008 12:57:05 -0700
Greetings!
Am reading data from Excel into Access to do some manipulations, then
bringing it back to Excel. A new field in the Access return data sometimes
has a null value. I see I can perhaps use the Access NZ function in the
query
to force it to a "" value rather than null.
However, as is, I have a ce ...
|
Create an export file using user generated title and export data t
Sat, 4 Oct 2008 14:42:04 -0700
The code below will export the recordset data to a know filename and known
path.
I want to be able to have the user create the filename using a message box,
and then have the code incorporate that filename, add a .kml extenstion to
the filename and then export the recordset output to it.
If at all possi ...
|
Update with Windows Mobile
Sat, 4 Oct 2008 13:11:01 -0700
Ok, I got this program done the way I want it, and it works. I need it to be
run as an Access Runtime program, and that is all set up fine. Now I need to
figure out a way to use it in conjunction with widows mobile 6.
I have a program that copies a file to my Mobile phone and when I update the
information ...
|
