|
Importing Excel Spreadsheet -- Getting Error Message
Hello,
I am trying to import a Excel Spreadsheet. I have 3 spreadsheets do import.
The first two imported perfectly. However the third one keeps giving me an
error message that the file wasn't imported when I click finish at the end of
the import wizard. The weird thing is the spreadsheets that did work were
created from this spreadsheet so most of the headings are identical. However
th...
|
2 |
14.09.2006 11:49:19 |
|
|
Why Access export three decimal but in text file only two decimal
Can any Access 2003 gurus kindly please advice me on the reason why Access
export table options exports to a text file involving number data type with
three decimal places but resulting in only two decimal places in my text file
content ?
Is it a bug that causes the last decimal digit to be truncated or some
settings that could help rectify this problem of mine ?...
|
2 |
14.09.2006 11:18:40 |
|
|
Run-Time Error 429: ActiveX component can't create object
Hello
I'm having problems with Error 429 and believe it is due to the
references I am using. My aim is to import all worksheets in an Excel
2003 workbook into Access 2003 but I keep getting the same Error 429
message. I've borrowed the following code (thanks BerHav) but need to
sort out this issue. I think I may not have all the correct references
ticked - all references I do have ticke...
|
7 |
14.09.2006 07:46:06 |
|
|
Large Delays (only on some servers) for Queries of Linked SQL db's
Hi,
I have an Access 2003 .mdb/.mde that queries linked tables from a SQL db in
order to provide Access reports to the user. It also combines with the SQL
queries, data from a few very small tables within the Access db.
On most systems/servers/networks, this app works well. But there are two
systems/networks (one running Server 2003 and another running Windows 2000)
where the que...
|
3 |
14.09.2006 03:13:02 |
|
|
I have an excel file that won't import into access
My file was originally a CSV file that was saved into excel format. I tried
to import the file into access and it gives me an error message stating "file
not imported". ...
|
4 |
13.09.2006 20:22:02 |
|
|
ODBC Error when importing to Excel
I have an Access query with a calculated field, that when I tried to import
into Excel | Data >> Import Data >> New MS Query, I received this error:
[Microsoft][ODBC Microsoft Access Driver]Numeric value out of range (null)
I do have another query that imports data OK. Any idea/resolution for this
error?
I have posted this on the Excel group as well.
Thanks.
--
whe...
|
3 |
13.09.2006 20:05:02 |
|
|
Does Excel have a bad security problem?
--
hawk3173...
|
2 |
13.09.2006 18:33:02 |
|
|
Importing from Excel using a linked File and an Append Query
I previously was importing data into my main data tabile via a linked excel
file which would be updated daily and an append query, and it has worked fine
for months.
I made some modifications to the database and now when the append query is
run it generates a "Run Time Error '3349' Numeric Field Overflow. What is
this? Why am I getting it and how do I fix it? How do I figure out wh...
|
1 |
13.09.2006 16:55:02 |
|
|
Importing an Excel spreadsheet into Access 2002
Hello,
I have an Excell spreadsheet, with ALL text fields. Now some of these
columns have data that looks like number data, but the Format Cells dialog
was used to set them all to Text. This was not sufficient to avoid the
dreaded Type conversion failure. I wildly guessed that including a single
quote at the beginning of the column with numeric appearing data on the first
row. Thi...
|
2 |
13.09.2006 15:58:01 |
|
|
updating fiields that match other fields
I have a database with 12 fiields. I dynamically pull this data into my .asp
website.
Two of these fields are important. The MODEL field and the PRICE feilds.
The price fields contains 2006 pricing. Once a year at year end, data entry
manually enters pricing into our proprietary system. I then can download a
..csv file and bring into excel. I now have a file with all our MODELS and the...
|
2 |
13.09.2006 15:04:04 |
|
|
Jet 4 Drivers and dBase III Access
I am currently supporting a client that uses an Access 97 application to
read and update information in a Dbase III database (which others use). The
user is getting a Runtime 2004 error message when attempting to execute
functions in the Access aplication. The error is happening on a macro that
updates the DBase III database (at least that is what the debugger is
showing). The user is on...
|
5 |
13.09.2006 14:33:01 |
|
|
Linking 5 databases
Hi, i'm not sure where to put his question as its awkward, so i hope this is
the right place.
i.ve created 4 databases to track students progresses. but i dont want the
staff to see 4 databases i want one database to at as a"front page" if you
like
E.g. the staff open a database and see a switchboard with Yr8, 9, 10, 11 and
click on the appropriate link.
i hope i have explained myself w...
|
2 |
13.09.2006 12:01:29 |
|
|
$ symbol
Where can I find the $ symbol in the Pivot table format. When I create a
pivot table I like to assign the dollar values with the currency $ symbol.
Before the format change in Access, there used to be the option in the
Tools/Customize area. I can't find it!...
|
1 |
13.09.2006 11:39:02 |
|
|
transferdatabase slower in 2003
i link table from an other access database by :
docmd.transferdatabase aclink ...
it is very slox in access 2003
an its fast in access 2000 with the same comlputer
why ?
...
|
1 |
13.09.2006 08:19:26 |
|
|
Transferdatabase slower in 2003
i link table from an other access database by docmd.transferdatabase aclink
....
it takes tree time longuer with access 2003
Why ?
...
|
1 |
13.09.2006 07:59:25 |
|
|
update rows in dbase4 from access tables vba coding
hello.
i want to update some rows in dbase4 file which is location in 'c:\final
directory'. the name of dbase4 file is 'data_final.dbf'.
well i tried to link this file to ms access but cant, as the length of
filename.
however the data_final.dbf contains sum of the data based in ms access tables.
i am trying to do this in vba. can anyone tel me how to link to / make a
connection to dbase ...
|
2 |
13.09.2006 05:47:44 |
|
|
Easiest way to automate running of Saved Imports in Access 07?
Hello,
I have about 100 files that I import into an MS Access 07 table every day.
I've saved the import steps for each as "Saved Imports." I'd like to be able
to run one after the other automatically rather than clicking on each one.
Is there an easy way to do this? Any ideas about macros or steering me in
the right direction would be appreciated.
Thanks and best regards,
Ad...
|
2 |
13.09.2006 03:06:01 |
|
|
help to import XML into MS Access using xsl
Adobe Indesign exports xml files from our application with the
following format:
<root>
<headline></headline>
<story>
<byline></byline>
<text></text>
</story>
</root>
When I try to import those xml files into MS Access 2003 using then
Application.ImportXML method, Access creates two tables because the
<s...
|
1 |
13.09.2006 01:24:59 |
|
|
Linking Access Dbase Records to Excel Spreadsheet
Can one link/hyperlink Access dbase records to an excel file?" ...
|
2 |
12.09.2006 17:33:01 |
|
|
Import excel date into column header - problems
I have created a linked excel table in my access database. The information
being linked includes calculated dollar amounts sorted by date. Each column
is assigned a specific month (column headers), and the months are calculated
based on user input. (So if the user enters Jan. 06 as the start month, the
ensuing columns are Feb. O6, Mar. O6 etc.)
When I link this table back into Access, I...
|
3 |
12.09.2006 16:01:01 |
|
|
Exporting data from multuple sub reports to excel
I am trying to find a good way to export data to anexcel sheet from multiple
subreports. Basically I am trying to take the data on an Access report and
also show it in Excel. The Access report is based on at least 10 subreports.
The "analyze with Excel "function does not work for this purpose. Is there a
way to to program Access to place the data from each subreport on a
spreadsheet in a...
|
4 |
12.09.2006 15:28:02 |
|
|
Importing from Excel is importing an invisible character
I have a spreadsheet that has a column of department names. One of the
departments is Women's Studies.When I import the data into Access and try to
do a search in that column for Women's Studies, the search does not yield any
results. When I write a query that is looking for Women's Studies I do not
get any results. If I manually add a record to the table and type Women's
Studies in the ...
|
4 |
12.09.2006 14:53:02 |
|
|
Updating data in Tables at two remote locations
I am involved in updating two same Access 2003, databases in two locations.
The only available link is by e-mail. This is because one Database is in my
Ship at sea and other is in office at shore. There is no Internet facilty on
board ship, but there is an e-mail system which uses Telex over radio
technology. An e-mail can be sent with attachments as e-mail.
My requirement is once user ...
|
5 |
12.09.2006 13:17:02 |
|
|
Problems not seeing all linked tables in Ms Access 2002
I currently have MS Access 2002 and Windows XP installed on my laptop. When I
try to use the link table option of linking table and select data type odbc
and select my machine type and log in I do not see all of my DB2 tables. This
process was working previously. Do you know a resolution to this problem?...
|
3 |
12.09.2006 01:00:02 |
|
|
Import German character (Umlaut) ?
Is there a simple way of importing J]RGEN so it becomes U with dots
instead of ]. I see there are many character sets in the Access Import
Wizard, but don't find any that makes it correct.
...
|
2 |
11.09.2006 19:53:04 |