ODBC Data errors in Access 2007
Tue, 18 Nov 2008 11:29:02 -0800
I opened an access 2000 mdb (that accesses SQL Server 2005 data) in my new
access 2007 (SP1 - 64 bit) and I am having 2 problems.
First off, I cannot use Linked table manager to update my connection to the
SQL server. I get a message saying ODBC call failed even when I select Prompt
for new location (I nev ...
|
Access or Excel creating unwanted 'backup of' files.
Tue, 18 Nov 2008 10:46:12 -0800
Excel is creating unwanted â??backup of*â?? files for me. My research indicates
that this behavior is a result of selecting of AutoRecover. I want/need auto
recovery, I am regularly receiving errors that kill my Excel session (I
believe these are SAP related, but, that is another to issue). My desired
beh ...
|
error 3274
Tue, 18 Nov 2008 02:22:03 -0800
help please
We have security software that outputs paradox format files. I want to
create a linked table to one of these files from Access but I keep getting
the 'External data not in expected format' error. since the paradox file is
output by software other than paradox itself, I do not what version of
...
|
Import Access query to formatted excel 2007 spreadsheet
Mon, 17 Nov 2008 11:51:01 -0800
In older versions of Excel, you could import an Access query into Excel and
it would assume the column width specified in the Excel spreadsheet. It would
also give you the option of not importing the column headings. How can you do
that with Access 2007 and Excel 2007
--
Judy L ...
|
Import command from Switchboard
Mon, 17 Nov 2008 11:12:01 -0800
I have an Access 2003 database that on the switchboard was an option to
import from a spreadsheet. I had used the FileImport command in the
Switchboard Manager. However, now it doesn't work in 2007. What is the new
command or the fix for this? I would still like the option on the
switchboard instead of g ...
|
Export to excel
Mon, 17 Nov 2008 10:17:03 -0800
In a mcaro, i export query to excel. It asks me to save thefile, and to
overwrite and the file, etc >> standard MS pop ups. I need to export to a new
work book to avoid the the pop boxes. Thanks ...
|
Choosing where the imported fields go in existing tbl
Mon, 17 Nov 2008 03:14:12 -0800
Importing a text file into Access
I would like to set up a process whereby i can choose where each field of
the imported text file goes in a template table.
i.e. i would like a prompt in the import process requesting me to enter the
destination field for each field in the text file to be imported?
--
...
|
|
|
Number Formating
Sun, 16 Nov 2008 18:45:01 -0800
When I use the following script to export a table to a CSV file I loose some
formating. There is one filed that is formated as SINGLE, Fixed, 5 dec.
When the export runs i get some scientific notation. (depending on how it
was stored). Is there any way to retain formating. Or is there anyway to
force th ...
|
import excel to acess-just a mess
Sun, 16 Nov 2008 14:32:48 -0800 (PST)
Hi
I am trying to import, or should say read, an excelarc to later work
wiht it for my accessDB. but this ends up in just a mess, i.e when I
look at the variable strSQLImport it's not even readable. Anyone knows
what I've done wrong.
Option Compare Database
Function RunImportExcel()
Dim strPathFile As Str ...
|
i need help
Sat, 15 Nov 2008 15:17:21 -0500
hi I would like to know if you have kids. from maddie walker thanks ...
|
