|
Can I link to tables on teradata?
the source is teradata and I am trying to set up odbc.....it appears to run
but then I get a blank table list......
Thanks!
Cheryl...
|
4 |
12/22/2008 8:12:02 PM |
|
|
Cut & Paste
Normally, I have a database I've been updating from EXCEL by copying the
records from EXCEL, then pasting them into the ACCESS table.
Recently, however, it won't let me do this. It has begun giving me the
error message:
The data on the Clipboard is damaged, so Microsoft Office Access can't paste
it. There may be an error in the Clipboard, or there may not be enough free
memory. Tr...
|
2 |
12/22/2008 8:03:29 PM |
|
|
Export data from current record to csv
Hi,
I want to add a command button to a form so that when a user clicks it
certain fields from the current record on that form are exported to a csv
file. At present the fields get exported for all records in that table.
1) Can I run a command that just exports the relevant fields from the
"current/selected" reord
2) Is there a way to prevent the data being output with "literals" (quot...
|
4 |
12/22/2008 1:13:53 PM |
|
|
drag and drop data from Excel into Access 2007
For years I have exported data from Excel into Access just dragging and
dropping it in the appropriate tables.
I just upgraded to 2007 and can no longer do this and have to import the
data using the "import" function.
Did this functionality disappear in Access 2007 or am I missing something ?
Thanks...
|
3 |
12/22/2008 7:57:05 AM |
|
|
Formating part numbers after import from Excel
I am importing part numbers from an Excel Spreadsheet into Access 2007 . the
field name is PART_NUM
The partunmber field is text and is 12 digits in length
I want to do an update query that will place dashes into the part number
after every three letters or numbers for example 000-000-000-000 or
123-abc-768-def
I have tried several combinations but none of them work properly
Left...
|
5 |
12/21/2008 5:51:01 PM |
|
|
Importing and Excel Sheet to MS Access
Hi..
Any one there can help me figure out how i can import excel sheet into MS
Access, but make access start importing from row number 4 in the excel
datasheet.
thanks....
|
4 |
12/20/2008 3:03:39 PM |
|
|
Problem with Excel file import
I have imported a file from Excel into Access 2007 but have got a number of
"Type Conversion Errors" on a number of the records. The columns in Excel
are formatted as dates and some of the data has been imported successfully
whilst some hasn't. I've checked the data in the problem cells in the
spreadsheet and they all appear to be OK they look like dates and are shown
as formatted as dat...
|
3 |
12/20/2008 1:06:57 PM |
|
|
Linking to a spreadsheet
I'm trying to link to a spreadsheet but the Linked Manager button is greyed
out. How do I do that? I'm using Access 2007. I've checked Help but it
doesn't seem to explain what to do unless I've meissed something.
Thanks
Tony...
|
3 |
12/20/2008 10:31:28 AM |
|
|
Transfer files to a new computer
I have an Access database in 2003 format on a computer running XP. I am
trying to move it to a new computer with a new Access 2007 program. I saved
the 2003 files on a thumb drive, and I can load them in Access on the new
computer, where they show up just fine by plugging the thumb drive into the
new computer and accessing the thumb drive. However, when I save the
database on the new ...
|
2 |
12/19/2008 10:36:01 PM |
|
|
Importing what file name?
Hi everyone! Happy holidays to you and yours! Thank you very much for being
such wonderful elfs all year long helping those of us who are nice to get our
toys to work right.
I have 2 macros, one that imports a .txt file and one that imports a .csv
file. The file name in the .csv TransferText Action is this:
="S:\RPS\PTS\CensusConversion\" & [Forms]![fCensus1Conversion]![PolNum] & ...
|
4 |
12/19/2008 9:47:47 PM |
|
|
Assigning blanks to values in lookup tables
I have a lookup table to identify my customer type. E is edu, G is Gov, and
NULL/blank is Std.
How to I get my Access Query to bring back the rows with this cell blank as
std?
Now it just brings back the rows that are populated with the E or G....
|
9 |
12/19/2008 6:23:05 PM |
|
|
Importing an Excel file
I have an Excel that I need to import on an almost daily basis into an Access
2003 database. I have created the fields in the table with names that follow
the normal convention, avoiding spaces etc. However the column names in the
spreadsheet will not be the same as the field names in the table. Is there
anyway that I can automate the mapping of the fields so that the data from
the colum...
|
5 |
12/19/2008 10:18:01 AM |
|
|
File to import is systematically created with date as file name.
The data file that I will need to import into the program every day is a
systematically created .txt file that will be kept in a folder with all the
rest of the past generated files. What is the best way to get the program to
grab the newest file and automatically import that with out user intervention.
I would assume that i might be able to do a left trim on the file name in
the impor...
|
4 |
12/18/2008 5:57:01 PM |
|
|
Export files to flash drive to be put on new PC
I have recently purchased a new PC I have not been able to transfer files
from one to the other. Please help, in simple terms if possible....
|
1 |
12/18/2008 5:20:00 PM |
|
|
Reusing saved import instructions
I have a database with about 90 tables that need to be imported and then
after a bunch of data manipulation, reimported. How can I from a Macro or VB
code access the saved import instructions for a a given table to kick off
the import again automatically?...
|
1 |
12/18/2008 4:51:00 PM |
|
|
Import Spec does not exist
I have an Access 2003 database that imports a number of different text files
once per week into various tables. These files have changes made to the
layouts now and then, in which case, I usually start a manual import, change
the Import Spec accordingly and save it over the other one. Now, I normally
do this in a test version and then when I am ready to make the change in the
live DB, ...
|
4 |
12/18/2008 2:31:01 PM |
|
|
Import creates extra rows
Importing or linking to a .txt file creates a blank row after every data row.
The file is \ delimited.
There is no problem on other PCs using this database and import......
|
1 |
12/18/2008 1:49:05 PM |
|
|
email attachments
I need a little help with sending email with attachments. I use Novel and I
am trying to send email with a text file attachment. I’m not sure if this can
be done with the SendObject method as I’m not sending a report or table but a
text file created from a table a DoCmd.TransferText command with a file spec.
Does anyone know how to do this? Access 20002, XP
Thanks,
Mark
...
|
9 |
12/18/2008 1:08:01 AM |
|
|
Access 2007 Browse to Import Excel File
I have trouble with the Browse function that will not work when I am trying
to import an Excel file. When I go to the External Data -Excel File,, the
browse button will not do anything. If I go to the same for Access File, the
browse function will work. An ideas?...
|
4 |
12/18/2008 12:44:46 AM |
|
|
200 COL Excel file with 700 rows -how to switch COLS & ROWS in ACC
I have an EXCEL spreadsheet with 700 lines of data and 200 columns. It was
set up with COLUMN A as the data header with the individual columns being the
data fields. ACCESS will not import this correctly since it requires the
first ROW to the the header as opposed to the first COLUMN. Is there a way
to switch this in ACCESS? The number of rows will NOT transpose in EXCEL as
they exceed ...
|
3 |
12/17/2008 9:55:59 PM |
|
|
Access Link
I am trying to set import to excel from an access DB Query. I use the wizard
provided an when prompeted I select the Query I want to use but get this
message Undefined Function'Week' in expression. Now the function it refers
to is working fine, it is located in access.
Odd think is on other queries it is running fine and imports to excel
perfect in those queries.
Any help...
|
1 |
12/17/2008 5:57:02 PM |
|
|
Importing to an existing database
I am new to access and I was wondering if anyone can direct me to some help
with importing excel worksheets that I receive weekly into an acess 2007
database that I have already set up and imported one sheet into? Thanks.
--
fortunman...
|
3 |
12/17/2008 12:11:55 AM |
|
|
Help in Importing from EXcel
I have several diferent sources of data incuding Excel spreadsheets and other
non access databases that I will be importing into an access 2007 database.
The issue is that part numbers are not uniform. Some have dashes in the part
numbers and others do. I am looking at the easiest way to import the data and
then once it is imported to make sure the required dashes are added to the
data.
...
|
5 |
12/17/2008 12:11:21 AM |
|
|
MS Access Coding - Edit SavedImportExport - Variable file name
I have developed a reporting database that imports data/tables from another
database. The only way I can get the information into Access is via HTML
table exports from the other tool.
So I decided to use the saved import capability of Access 2007. I found out
too late that the path and filename you provided when saving the import is
not relative. In otherwords the file to import mus...
|
2 |
12/16/2008 11:55:01 PM |
|
|
What is the limit on fields I can import into a table?
I'm trying to import fields via an odbc. Is there a limit as to the number
of fields Access will IMPORT. The table I'm trying to import from has
aproximately 300 fields. Thanks for any thoughts...
|
3 |
12/16/2008 11:45:29 PM |