|
Problem with Linked SQL Server Table
I am having a problem exporting a linked SQL server table from Access 2003
to Excel. The file is about 2,000 records with several columns. The
problem
is that when the table is imported into excel some of the records are not
coming across with the correct data and when numeric fields are summed the
totals are wrong.
When I export directly to Excel from the SQL server using DTS, I don't ...
|
1 |
21.08.2006 17:58:47 |
|
|
Presentations
How do I make sure that my presentation that I imported is available to the
attendees of the meeting?...
|
1 |
21.08.2006 14:41:02 |
|
|
First record is always blank
Hi,
I have 3 tables and I populate each by importing 3 spreadsheets. The 3
spreadsheets are basically set up the same way and on all 3 spreadsheets the
1st row contains column headings. The spreadsheets are created via VBA by
extracting data from a series of formatted spreadsheets that are submitted
from different divisions (budgeting data) to new spreadsheet files that are
saved/cl...
|
4 |
21.08.2006 13:35:21 |
|
|
To update shared access file through http
Hi,
I need to update my access file which is available through internet
i.e. http.
What are the different ways avaialble for this?
I tried liking that table at my client application which is again a
access by specifing the URL "http:\\localhost\temp\db1.mdb" at Filename
text box, but I am getting error "Not a valid File Name."
Your help is appriciated.
Thanks
Ashwini
...
|
2 |
21.08.2006 13:34:59 |
|
|
cannot import delimited from MS WORD to access
I want to import a MS Word file to a new Access data base table. I continue
to get the message that I cannot import because the "object" is read only,
and yet I can open the document and edit it in any way. What is the problem?...
|
3 |
21.08.2006 10:34:50 |
|
|
Find number of files
I have a tiny db that imports a txt file, deletes some rows, does some
calculations, deletes the file and then prints out a report. (quick
explanation)
To make sure there is only one file imported, and also the correct one, I
force the user to cut and paste from one folder to another before clicking
the button that imports, does all the stuff and finally print and close
Access.
Is ...
|
2 |
21.08.2006 05:32:54 |
|
|
Access Default database folder keeps changing to Program Files
I have an Access application that imports Excel spreadsheets into tables
using Transfer Spreadsheet Macros. However, The default database folder
keeps changing and the following error keeps coming up when a transfer
spreadsheet macro executes: "The Microsoft Jet database engin could not find
the object 'C:\Program Files\Common Files\SYSTEM\MSMAPI\1033\Tbl_Leads.xls'."
However, the def...
|
4 |
19.08.2006 19:10:50 |
|
|
Type Conversion Failure with dates
Every day I run commands that truncate a table (tblSAR) and import new data
from an Excel worksheet. All of a sudden I am getting a Type Conversion
Failure for the date fields. I can see that some of the dates in the Excel
worksheet are in the format mm/dd/yyyy (with a leading zero) and some are
not. Excel thinks the fields with a leading zero are text fields with a
format of "General...
|
6 |
19.08.2006 18:40:29 |
|
|
Importing DBF Databases
I need allow users to import DBF databases into my Access application.
However, because this application is going on the market, I cannot allow them
to directly alter anything, and I therefore need a way to link my forms to an
imported table that (theoretically), could be named anything.
To overcome this, I am trying to get Access to import the data, copy it over
to a table that I KN...
|
17 |
19.08.2006 07:27:50 |
|
|
Appending Records
I have 2 databases with the same tables. I need to merge the data from
database 2 into database 1. I created an append query but I keep getting a
"not enough space on temporary disk" error. I even limited it down to 3
months worth of data and i still get this error. if i limit it down anymore
it would take me way too long to append all the data from every table. Help!...
|
3 |
18.08.2006 18:07:01 |
|
|
Records Lost When Linking to a Dbase File
I have a dbase 5 file that contains 46,873 records. When I import the file,
all 46,873 records show up but when I link to the file I only get 730
records. Importing this file takes a very long time so I'd perfer to link to
it instead....
|
2 |
18.08.2006 18:04:02 |
|
|
Why does the data type change when import/link an excel worksheet?
I am hoping someone out there can help me. I importing excel spreadsheets
into an access database. The excel files will be updated monthly so I am
linking them. However, when I do link them, for some reason the data type
changes and I get mismatch errors when I run queries. I know for a fact that
before I link the sheets, I change the cell format in excel to text. But
once I get it ...
|
2 |
18.08.2006 16:59:29 |
|
|
Access and Excel New Database Query Problem Followup
I just ran into this exact problem. I was trying to connect to a
secured database. I got past it. The steps that I used follow.
Edit the datasource (Start==>Administrative Tools==>Data Sources).
Choose the tab for the correct DNS type (User, System or File).
Select your connection from the list.
Click on Configure.
Click on Select and type in the path to the .mdb file.
Select A...
|
1 |
18.08.2006 01:26:11 |
|
|
how to transfer cvs excel file into outlook contact
does anyone know how to import the data and set up a contact list...
|
3 |
17.08.2006 18:52:37 |
|
|
Export Access Query to Excel (both 2003)
Hi everyone, I'm new to this forum and beforehand, I'd like to thank everyone
for any help received.
I have searched the archives and read a number of links within them and I
can't figure out how to export a qry to xl.
I'm not very good with code, I can read it pretty well, but I have no idea,
even with the code builder helping, exactly how to write the syntax.
If anyone could help me ...
|
5 |
17.08.2006 17:41:03 |
|
|
Sample file for Customers, Orders, Payments etc
Hello all
I am trying to design a software in MS Access for my own use regarding
Customers, Orders & payments. I need a sample file to refine my knowledge. If
anyone can direct me I will be grateful.
Best regards,
isons
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-externaldata/200608/1
...
|
4 |
17.08.2006 13:40:03 |
|
|
PASSWORD PROBLEM in .MDW FILE
we are not able to access our mdw file. it says: Not a valid account or
password. I guess the password was changed somehow. How do we hack into
our mdw file and find out our password?
please please help
thanks
...
|
5 |
17.08.2006 10:56:02 |
|
|
Need Help getting current key value after adding ADO record in SQL
I use an ADO connection to add new records to a SQL Server database. After a
new record is added iit is supposed to be the current record. Yet, I cannot
seem to retrieve the primary key (autogenerated) for the record. I just get a
zero. The added data goes in and can be queried and viewed. Here is a code
snippet:
Dim cnSQL As ADODB.Connection ' SQL server
Dim rsTR As ADODB.Re...
|
2 |
17.08.2006 10:19:25 |
|
|
Importing outlook (including emails, etc. listed under "activities
Successfully imported contacts from my office computer (which is connected to
a LAN) to a new home computer, but the record of emails and notes, etc. under
"activities" did not import. Using MS office 2003 & Outlook 2003 & Windows XP
on both computers. ...
|
2 |
17.08.2006 05:08:25 |
|
|
Imported numbers from Excel change to scientific notation
While in Excel I have changed my 10 digit account numbers into text format,
and then I import them into Access. Frequently, these numbers do not convert
correctly. They get converted into scientific notation and the trailing
numbers are lost. While converting Excel into Access, is there some way to
keep all the digits intact?...
|
5 |
16.08.2006 19:25:01 |
|
|
Trying to import MS Access Cells to MS Excel.
I working on a project that uses single cell data for access to fill out
single cells in Excel. Everytime I try and and add the "GET EXTERNAL DATA" to
my Excel Template it wants to add the whole query rather then just single
cell information.
For example: I have a job number and I want all the information for that
job number to update my Excel Template Fields such as PO Number, Custo...
|
2 |
16.08.2006 19:18:27 |
|
|
Access loses 1 row and 1 col when importing spreadsheet
We've been using a macro to import Excel spreadsheets into an access 2002
database. After 5 months of this we found an error on a report. It turns out
that access is ignoring the last row and last column of the spreadsheet. If
the spreadsheet has 12 columns and 1000 rows the table will have 11 columns
and 998 rows of data (one row is converted to field names). This happens
when using Transfer...
|
5 |
16.08.2006 19:01:42 |
|
|
ODBC/Jet DBE and new computer
I have recently purchased a new computer that came with access 2003
pre-installed and am trying to move an access 2003 dbase containing linked
tables to it from my old computer. I have set up an odbc connection on the
new computer just as it was on the old and i still keep getting"jet database
engine cannot find...." errors. Any suggestions as to what I may have missed
????
Thanx in a...
|
1 |
16.08.2006 18:49:02 |
|
|
Missing formula bar
The formula bar has disappeared from my Excel page, even for new sheets.
It's not in toolbars.
Any ideas?
...
|
3 |
16.08.2006 18:03:21 |
|
|
import records
I am new to Access 2003. I have two tables with identical fields. What is the
easiest way to copy or merge the records from one table into the other. I
tried "cut & paste" but that didn't work....
|
2 |
16.08.2006 17:24:02 |