|
Import Excel Spreadsheet and expand into multiple rows
I am trying to import an excel spreadsheet, but have run into a data issue.
One of the columns I am trying to import containes multiple values, separated
by a comma. For each value in this column, I need to create a new row during
import, replicating all of the values from the other columns in the
spreadsheet.
Is there a way to do this systematically?
--
Thanks, Gina...
|
2 |
26.07.2006 20:07:01 |
|
|
Importing Excel 4 in Access 2003 problem
I cannot seem to import an Excel document (exported from an accounting
package in Excel 4) into Access 2003
Any ideas, do I need some sort of add-in or dll???
weird...
|
4 |
26.07.2006 19:51:16 |
|
|
Using Excel Form to Select Parameter for MSQuery
I have queries which have SUMREV01 SUMREV02, etc. as fields. I'm creating a
monthly report in excel which pulls this Revenue data from access using
msquery. I want my boss to be able to select which month she'd like the data
for on a form in Excel and it pull the correct data. As the Revenues from
different months are different fields instead of criteria...I'm not sure how
to do this or ...
|
3 |
26.07.2006 19:09:01 |
|
|
Adding Rows during data import
I am trying to import an excel spreadsheet, but have run into a data issue.
One of the columns I am trying to import containes multiple values, separated
by a comma. For each value in this column, I need to create a new row during
import, replicating all of the values from the other columns in the
spreadsheet.
Is there a way to do this systematically?
--
Thanks, Gina...
|
10 |
26.07.2006 18:04:02 |
|
|
Link query to Excel
I want to link data from a table to an Excel worksheet. I have used Data, Get
external data, New database query, etc. However I want to import only certain
records but not using the boxes in the Excel wizard but more like a parameter
query in Access where the user can select certain data only. Can I do the
same in Excel? or, Can I import my parameter query directly into Excel?
By the wa...
|
3 |
26.07.2006 14:30:01 |
|
|
File Import Slows Down
I periodically import large text files into a database using vba code. The
importing starts out very fast (1+mb/sec), but then slows down considerably
(to about 33kb/sec) after a couple minutes. Consequently, each file is
taking about 30 minutes to import. What would cause the imports to start out
very fast, and then slow down so much? I'm importing from the harddrive, and
there's pl...
|
3 |
26.07.2006 13:50:01 |
|
|
"get external data" function
The "get external data" option disappears when i open a particular database.
Is this something that is written into the database? (ie. to prevent people
from importing data). if so, can it be removed? if not, what could be causing
this? I have full read write acces to the database and can enter data
manually without a problem.
Any suggestions would be greatly appreciated.
Thanks in a...
|
3 |
26.07.2006 07:27:02 |
|
|
Open MS Mappoint file from Access
Hi
I am trying to open a MS Mappoint file located on the H drive through a
button in a form that I have made in Access. I used the Command Button
Wizard/Application/"run application" and then I put in the complete path to
the file (H:\Market mapping\H:\Market mapping\Map - Municipal with
facilities.ptm) but when I use the button the error "invalid procedure call
or argument" appears. Wh...
|
2 |
26.07.2006 05:55:13 |
|
|
updating data
I have a split mdb on a LAN (LAN 1) at one location and a different split
mdb on a LAN (LAN 2) at another location. Many miles between them. With a
VPN connecting them.
My application on LAN 1 needs updated data, say daily, from 3 tables from
the database on LAN 2. To date I have just been copying and pasting the
three tables into the BE mdb file on LAN 1 from LAN 2 BE mdb file. I ...
|
2 |
26.07.2006 05:44:38 |
|
|
import xml doubles up my tabes
i have imported an xml file which includes about 7 tables, now i have an
updated xml file to import, but it has created 2 copies of each table, e.g.
client and client1. is there some way to import the xml file to update and
overwrite the data in the existing table, or some option i need to change to
do this?
thank you...
|
1 |
25.07.2006 23:08:01 |
|
|
link ranges from excel
1 I have a range (non contigious cells) defined in excel. When I try to
create a linked table in access using this range, the range does not appear
as a choice.
2 A more simple task, I thought: I have two identically designed tables. I
want to look at all the records in both tables using a query, without
creating a table....
|
3 |
25.07.2006 21:20:01 |
|
|
Unable to Update Linked Table
Our office uses Access 2000 as a front end to a SQL
server 2000 database.
Each client has it's own copy of the access .mdb file on
their computer.
It has been up and running for about a year and half but
recently have been getting sporadic ODBC timeout errors.
The syntax of the error is:
ODBC -- update on a linked table 'tableName' failed.
[Microsoft][ODBC SQL Server Driver]Timeout ...
|
1 |
25.07.2006 20:05:24 |
|
|
importing data to existing access table
I am trying to set up a Word web form for customer to fill in registration
information, the info will then be saved in a spreadsheet file on a server,
accessed by IE through specified web address. I keep an Access database of
registrations processed and I would like to import the spreadsheet into the
database weekly for processing,tracking and reporting purposes. Is it
possible to set up...
|
1 |
25.07.2006 13:41:02 |
|
|
Linked Tables and Upsizing
Thanx in advance for any info that anyone can provide.
I have a small access DB that we are using to query a couple of third party
databases. I am trying to upsize this to an SQL server.
The access db uses linked tables to the 3rd party databases and everything
works fine untill I upsize. It appears that once I do this the tables do not
update on the sql server like they do in access. Is...
|
1 |
25.07.2006 12:35:01 |
|
|
Telnet form within Access 2002
could anyone give me some sample code or anything that would help
create a form that displays a telnet connection in access 2002.
...
|
2 |
25.07.2006 04:17:12 |
|
|
Copy data
Hi there,
I have two Access 2000 db's where the one is a 100% duplicate of the other.
I have added data to table #2. How do I copy this newly added data to db
#1? The fields and everything are the same. It is about 30 records.
Thank you so much.
Deon...
|
2 |
24.07.2006 14:48:10 |
|
|
Ms not initialized
I resently upgraded Norton and now my DB and daily reports get stopped from
forwarding to receipients. My nightly transfer fails with; Error MS not
initialized. I'm computer illiterate so please help me!!! One person told me
to dump? MS and reload and another said NO that it would get rid of
everything from my DB that I need to transfer. If you can guide me through a
solution please cont...
|
1 |
24.07.2006 13:49:02 |
|
|
Convert Hierarchial Report to Access Table
I need to append the header record to the detail records in a
hierarchical report to create a database table. I was hoping their was
a command line tool that may assist.
Thanks!
Input:
Header 1
Detail 1
Detail 2
Detail 3
Header 2
Detail 1
Detail 2
Output:
Header 1 Detail 1
Header 1 Detail 2
Header 1 Detail 3
Header 2 Detail 1
Header 2 Detail 2
...
|
4 |
24.07.2006 13:29:44 |
|
|
How do I import a number from a text file with a coma on it ?
...
|
4 |
24.07.2006 13:26:14 |
|
|
Access to XML via module
I need to have queries saved as xml files without the formatting AND have it
done as part of a module.
I tried creating a macro and then converting, but the fact that this is an
Access 97 app didn't allow for exporting data into .xml.
It is probably simple, but I have hit the wall...Can anyone help??
Thanks,
Mark...
|
1 |
24.07.2006 13:24:01 |
|
|
Import/Export Browse Box
Am trying to create a simple database for people to use and they always get
stuck with import/exports. As the locations/names change I can't use a macro.
I found this to start with (http://www.mvps.org/access/api/api0001.htm), but
my knowledge of code etc. is nil... Any new functions in Access 2003 that can
bring up a browse function for imports AND exports?
Either that or some more de...
|
2 |
24.07.2006 12:43:01 |
|
|
missing zeros when importing from excel
when I import excel into Access 2003, the leading zeros are missing.
example 015-201-802 in excel shows up in Access as 15201802 with the first
zero missing...
|
2 |
24.07.2006 12:06:25 |
|
|
Import of dbase files
I am having an issue importing some Dbase ver III/IV files into Microsoft
Access. I am able to open the .dbf file in Excel and view all the data
properly but when I try to link/import the dbase table into access, I receive
"External Table is not in the expected format" How if it opens in Excel is
it not recognized in Access?...
|
4 |
23.07.2006 17:05:01 |
|
|
exporting from access to outlook
I use Access to track my banquet functions. Menus are created as well as
rooms selected and dates and times of functions. Can I export the dates and
times with a note field into Outlook?
--
tadair...
|
1 |
22.07.2006 19:27:01 |
|
|
Make-Table query outputted to Sequel?
I currently have an Access database that doesn't store any of my data, but
runs a variety of append and make-table queries. The make-table queries are
exported to individual Access databases. The problem I'm running into is
that some of these tables are arriving at the 2GB limit. I'm sure this is
not the most efficient way to do this, but I'm a relative novice in Access
and am brand n...
|
1 |
22.07.2006 15:51:01 |