Importing Tables
Thu, 23 Oct 2008 10:19:01 -0700
So I have a series of queries that I run on Table A. Each month, I get a new
updated table, Table B. What I would like to do is change the queries that I
run on Table A to Table B without having to go into the SQL to manually
change their names. I know this is a stupid question, but please help
regardless. T ...
|
Importing in Access from Excel creating relationships
Thu, 23 Oct 2008 08:58:12 -0700
Hi,
I am hoping someone can help me with this question. Problem: we ended up
with 2 copies of the access database and need only one containing all of the
information. Could not copy and paste the data from one table/database to
another and there are too many records to easily re-write them in the table
...
|
Re: '<linked table name> isn't an index in this table' error in
access 97 database
Thu, 23 Oct 2008 08:51:05 -0700 (PDT)
This worked. I'm really shocked since no one else (except the
president) had any problems. They must have installed the "Karma 98"
components! Oddly it wouldn't let me run repair, till after I ran
compact, but otherwise it's all set now. Thanks again (to all)
Mick
On Oct 21, 10:14 am, "Joan Wild" <jw...@nos ...
|
Import Excel to Access
Thu, 23 Oct 2008 07:35:01 -0700
hi,
i have a list box that displays all imported weekly report....
SELECT [Name] FROM MSysObjects WHERE [Type]=1 AND [Name] LIKE
"*exception06W*" ORDER BY [Name];
i have this Command0 that imports my weekly report to Access and i have this
code...
On Error GoTo Err_Command0_Click
Dim i As Integer ...
|
Incorrect collating sequence
Wed, 22 Oct 2008 21:10:00 -0700
While linking paradox database with the access I am getting the incorrect
collating sequence error?
I tried modifying paradox driver registry entry of collating sequence to
international. It fixed the error but i could not see the data and column
were displayed with header column1, column2 and so on.Actual ...
|
Importing excel data from row 2
Wed, 22 Oct 2008 17:45:01 -0700
How do I just import everything from row 2 in the excel file??
I don't want to define a range, eg A2:V750, as each month when the data is
imported, it will be a different amount of rows. I just want to import data
from row 2 downwards.
Any help would be much appreciated. ...
|
Get External Data2
Wed, 22 Oct 2008 15:46:59 -0700 (PDT)
I am importing data from multiple Excel files into an Access table. I
can perform this task for one table using the code I pasted below of
which I found in this group. The CreateTableFromExcel() function is
designed to receive the Excel file location and name as input. How
could I modify the code below to loo ...
|
|
|
Get External Data
Wed, 22 Oct 2008 15:33:15 -0700 (PDT)
I'm importing data from multiple Excel sheets into an Access table and
found that the code posted earlier by another user is a good starting
place for me. However, the spippet of code below starts copying data
on row 1 of the Excel sheet. Since the Excel sheets I am accessing
may not always have records starti ...
|
Can form be open during import
Wed, 22 Oct 2008 12:39:01 -0700
In a macro, I delete a table, for example TableOne, transfertxt delimited to
to a table named TableOne.
Question - while the macro runs, can a user have a form open that has a
couple controls that reference fields in TableOne in dlookups and queries?
The forms' data record source is not TableOne. Thanks. ...
|
Export/Import .dat file extension
Wed, 22 Oct 2008 10:30:04 -0700
I have a large number of databases which are set up to read in and export
text data to files with extensions other than the defaults (.dat, .work,
etc...). In Access 2003 I was able to modify the registry to allow for these
extensions. However, I have now upgraded to Access 2007 and cannot seem to
import or ...
|
