|
Importing Spreadsheet/Linking spreadsheet
This is my first time to attempt this. Your assistance will be greatly
appreciated!
I receive information daily via email in the form of an excel worksheet. I
need to bring that information into my access database.
I have a query from which I created a table. This query is emailed to
end-user who inputs information daily and emails back to me. I have saved
this info on my drive C...
|
8 |
27.05.2006 10:49:11 |
|
|
SENDOBJECT - Sending Email on Behalf of another User
I'm using the SendObject to programatically send emails , which is working
great.
I recently got a request from management to send email on behalf of another
user,
say sales@anycompany.com
I know how to do this from within Outlook using the Delegate option in
Exchange,
The question is:
How do I send email using the FROM option that outlook
uses in the
Se...
|
3 |
28.05.2006 19:03:50 |
|
|
import xml data into Access 2003 - deletes all data in file
All,
I have created an xml file (from a report) that contains 3 types (tables)
of data.
The data structure is similar to:
<root>
<table1>
<row><col1>...</col1>...</row>
<row><col1>...</col1>...</row>
</table1>
<table2>
<row><col1>...</col...
|
2 |
26.05.2006 18:18:01 |
|
|
importing excel 2003: error "there is no object in this control"
I am running microsoft 2003, when i try to import an excel file it gives me
an error message saying "there is no boject in this control". When i click OK
a box comes up with nothing in it, when i click NEXT or CANCEL i get nothin.
I saw others asking this question but with the microsoft 97. Can anyone help
me? ...
|
2 |
25.05.2006 20:39:10 |
|
|
Access does not open ODBC dialog when importing or linking
Access 2003 does not display the ODBC dialog box when you select ODBC Data
Sources when trying to import / link tables. I have reinstalled Access, to
no avail. I can access the system odbc configuration through admin tools.
Does anyone know how to correct this problem, short of reinstalling the OS?
...
|
5 |
25.05.2006 19:24:30 |
|
|
Import Excel data - File not open
I have a macro built that imports data from an excel file. This works fine
when the actual excel spreadsheet is open. It will not work if the
spreadsheet is closed.
Can I add a command to my macro that opens the specific spreadsheet, then
closes it when the data is imported?
or
Can I import the data without opening the spreadsheet some other way?
Thanks for your time....
|
12 |
25.05.2006 13:26:01 |
|
|
Access to Access transfer of external data?
OK:
Our data comes in to us in Excel spreadsheets, we upload that data into
a local Sybase database, it's quick and presents no problems, but...we
also need to upload that data into an Access database located overseas
which means going across our network, which takes forever.
We're thinking we can get around this by uploading that data into a
local Access database during business hours a...
|
4 |
25.05.2006 05:35:04 |
|
|
export wizard not running
I'm trying to run the export wizard so that I can establish a specification
for a macro that uses the transfertext command. However, the export wizard
doesn't run. It does give me options when I use the file, export command, but
it doesn't allow me to save anything that could be taken as a specification.
Sandbox mode is disabled as far as I know.
Any help?...
|
2 |
24.05.2006 23:52:01 |
|
|
Unable to Import Excel File
I've just upgraded to Office 2003. I am trying to import a simple EXCEL file
and get an error message.
Unable to access information in the file (gives filename). Please check that
the files exists and is in the correct format.
I've tried other files that I've imported before and other databases that
have had data imported (prior to the upgrade). So I know my problem is in
the insta...
|
4 |
24.05.2006 20:55:39 |
|
|
Blank rows before data in Excel table
I have a series of EXcel workbooks I receive each month from 3rd parties.
The workbooks have a consistent column layout. There are some blank rows
before the header rows for the columns and then some more blank rows before
the data. This is consistent for all the books.
I set up a table, as a template, in Access with the record layout the
workbooks have. When I try to use Get Exte...
|
2 |
24.05.2006 19:10:11 |
|
|
Import an SDB file
How do I import an SDB file database into my access database. When I want to
import the file it does not show the file but I can open this files in
Access? Even if I try to use an append query?????
...
|
5 |
24.05.2006 17:56:05 |
|
|
Change back the import wizard
In older versions of Access, when we wanted to import data into an EXISTING
table, we could map the fields of the external data to which existing field
that data was meant for - in case the field names didn't match. I just spent
an hour helping my payroll manager tweaking csv text files and excel tables
in order to import them into a dbase she uses to track 401K data for our
auditors.
...
|
8 |
24.05.2006 17:38:33 |
|
|
Inventory w/realtime update?
I'm not sure if this can be done but here it goes...
I have an Equipment Inventory system that keeps track of each
PC/Printer/Scanner/Server and so on... along with memory, HD, OS, software
etc... is it possible to do this in realtime mode and have it update my
database that I created in Access 2003?
...
|
4 |
24.05.2006 17:14:02 |
|
|
exporting XML
I am exporting an access 2002 database to XML so that I can import it into
InDesign. Is there a way that I can make my currency field export including
the formatting eg. appear like £12.00 instead of 12?
I would be grateful for any help in this?
Many thanks,
Alix...
|
2 |
24.05.2006 16:42:43 |
|
|
transferring data
I am creating a database that allows a person to create and customize a new
database
according to how they want it. So the database I create should be able to
allow someone to click on a "new" button which then takes the user through a
series of steps that sets up a new customized database to use. I'm fairly
new to access so can someone tell me how I can create my database so when
someone w...
|
3 |
24.05.2006 16:01:02 |
|
|
Importing Hyperlinks from Excel to Access
When I import an Excel file containing hyperlinks into Access, the hyperlinks
turn into text and no longer hold their links. I am using the
TransferSpreadsheet function in Access to import my table. I have done a bit
of searching a come across this code:
UPDATE tblTest SET tblTest.hyperdocs = "#" & [hyperdocs] & "#"; (where
tblTest = name of table and hyperdocs = name of hyperlink field in...
|
4 |
24.05.2006 14:44:52 |
|
|
Update links to multiple backends
I have an Access frontend/backend combination that gets moved around a
lot. To deal with this, I've been using the code found at:
http://www.mvps.org/access/tables/tbl0009.htm
It runs every time the frontend is opened to check and make sure it is
connected properly to the backend (if not, it opens a dialogue box to
choose the new location of the backend). This all works great - until
n...
|
6 |
24.05.2006 13:44:47 |
|
|
xml
Hello. how to export data from Acess 2000 to predefined xml format ? There is
a *.xsd file. I need to generate the xml is VBA. SO I presume I can use
ExportXML method. If I import the xml to access, it creates multiple tables.
so it seems I need to update data in those tables and export them back to xml
to generate an updated xml ?...
|
1 |
24.05.2006 10:39:02 |
|
|
Importing Text
I have several word document over 100 pages each. Throughout the document is
the information I need to pull. There would be about 6 fields - Name,
Address, etc....
There has to be an easy way to pull this information from the documents.
Thanks,
Baracuda...
|
2 |
24.05.2006 06:13:29 |
|
|
Trying to import 12 digit number into Access
I'm having problems importing a 12 digit number into Access. I've tried to
import from various file formats, Excel, Monarch, Dbf... When data is
imported into Access, the 12 digit numeric field is changed to a scientific
value. (i.e. 111111111111, becomes 1.0000+E11) I would like to be able to
do this import daily without having to go to design view of my table and
setting the forma...
|
5 |
23.05.2006 22:44:28 |
|
|
dbase3 conversion
Hello,
I am the head of a small non profit (501c3) feline registry that
several years ago had a dbase program created to keep track of members,
cats, registration numbers, etc. The son of the original founder wrote
the program, and ive been trying to convert it to Access. I can get to
all the data, the problem lies in that I cannot access the indexes to
know how all the data fits togeth...
|
5 |
23.05.2006 19:30:01 |
|
|
Tool Required to Convert
Hi ,
Can Someone help me out to Create a tool in Access which Converts
Unaligned data to aligned data in Access.
example of unaligned data:
xyz x...@something.com
--->x...@something.com 05/12/2006 18:25:43 Local
Output should be:
xyz x...@something.com 05/12/2006 18:25:43
file consist of lotsa data and which are not in order, p...
|
2 |
23.05.2006 19:15:43 |
|
|
Import/Export to remote laptop?
To allow a user to work remotely (not on our network) with an Access 2002
database, I intend to replicate it. It is an estimating database and each
project has a ProjectID which is an AutoNumber field. This shouldn't be a
problem if an existing project is exported to the remote/laptop, but what
happens if the user adds a project on the laptop and a new ProjectID is
generated? Is there...
|
2 |
23.05.2006 19:12:42 |
|
|
Key Violation using TransferSpreadsheet
I have an Access procedure that uses TransferSpreadsheet to transfer the
results of four queries to separate sheets in the same Excel file. It worked
as expected until I added one more field (the same field) to each query. Now
the results of the first two queries are exported out as expected, but for
last two queries I get an error message:
The contents of fields in 16 records(s) were...
|
6 |
23.05.2006 19:06:41 |
|
|
FE/BE refresh links problem
I have a split database which uses an FE updater. Because this used by
different teams each with their own BE, when a new version is released one of
the first things it does it set up the links to the relevant BE.This 'path'
is passed to it using cmd in the ini file.
However, I am finding that this code hangs if somebody is already in the
system (and therefore the BE). Code is as follows:
...
|
4 |
23.05.2006 19:00:04 |