|
Import date/time into Access
I am trying to import date/time information from a .csv file. The information
is in iso format of YYYY-MM-DDTHH:MM:SSZ. How can I get this into a datetime
field of Access. Also, does Access actually store a date and time in a single
field, or must they be broken into a date field and a time field?
Thanks,
Dave...
|
7 |
27.07.2006 19:16:05 |
|
|
import yahoo address book
Can recieve messages form yahoo, and send. But can't import my yahoo address
book.
created the csv vile per yahoo, and it is on my desktop. but when I try ot
import get: Translation Error. a file error has occurred in the csv
(windows) translator while initializing a translator to build a fied map.
Verify that you have the correct file, HAVE PERMISSION TO OPEN IT, and is
not open in...
|
2 |
30.07.2006 05:50:42 |
|
|
Exporting with Range?
Hello all,
I'm wanting to export a table to an excel spreadsheet, but putting the data
in a location of my choosing.
TransferSpreadSheet help says you can not use the range on an Export.
However, I did a search here and someone said that it would work.
It partially works, but I can't seem to get it to allow me to put it in a
workbook. Also, it will not overwrite if the file exists...
|
3 |
29.07.2006 17:39:01 |
|
|
Export report as HTML problem
I need either 1 of 2 things. Either a way to export a single page of a
report to HTML or a way to export every page of my report to html and have it
draw the file name from a field on the report.
I have tried to rename the HTML with the following using a macro. It will
name the first page correctly but each consecitive page is the same as the
first but followed with Page1, Page2, Page...
|
1 |
29.07.2006 10:26:01 |
|
|
Import ODBC Database using VBA
Hi all,
I want to import a DBF file (which is created by Foxpro 2.6 for Dos that
have a MEMO field), via FoxPro ODBC, using VBA. For example: Import
C:\dbf1.DBF to Table1 in DB1.mdb by clicking Button1 on Form1. I hope this is
clear (since English isn't my First language).
Thanks in advance....
|
2 |
28.07.2006 18:30:01 |
|
|
How do I export specific information in Access?
...
|
1 |
28.07.2006 17:46:02 |
|
|
Transfer table to fixed length text records
I have a table the consists of two fields that together make 300 bytes. When
I export this delimited file to text there appear to be 300 characters.
However when this text file is imported to a well established package, it is
validated for having records that are 300 bytes long. Needless to say my text
file fails this check. I have reduced my table size to allow for a line feed
or carria...
|
6 |
28.07.2006 17:34:34 |
|
|
TransferSpreadsheet Type Conversion Failure
When transfering .xls into Access table I get a Type Conversion Failure
error after the transfer. Example: I have 1 worksheet with multiple columns
in Excel. Some columns contain both numeric and text values. If the top row
of the imported sheet is numeric and several rows down is Text in the same
column the error occurs. If the top row is Text and everything below it is
numeric the ...
|
1 |
28.07.2006 16:01:02 |
|
|
Import while DBF file is in use
Hi there,
Is it possible to import a DBF file while it is opening (in use) by another
program (such as Foxpro 2.6) but have no access - I mean the records have no
change. Because the DBF files are in use almost the time, and I want to
update everytime I click a button.
Many thanks....
|
5 |
27.07.2006 23:58:01 |
|
|
MS Access Link Tables using ODBC stopped working
The problem is with Norton 2006 Anti virus and the new Norton AntiVirus
Plug-in. It blocks the ability to bring up the ODBC window in Access.
You will need to turn off the plug-in. I pasted the details below.
Turning on and turning off the Norton AntiVirus plug-in for Microsoft
Office
Situation:
This document describes how to turn on (enable) or turn off (disable)
the Norton AntiVirus p...
|
1 |
27.07.2006 20:45:59 |
|
|
Adding a Title Row to Queries Exported in .xls
Pardon me if this is a basic question. I have a query that gets exported to
Excel and am wondering if and how to add a title to the top row of the
exported query. Any thoughts or suggestions?
Thank you in advance....
|
4 |
27.07.2006 19:22:50 |
|
|
How to Import Data Inside the Text Box in Excel into Access?
Is there a way to import data from a text box in Excel into Access? I need to
find an automated way to do this because I am doing this task for a large
number of spreadsheets.
Any help would be very appreciated!!...
|
2 |
27.07.2006 19:13:42 |
|
|
Linked table returning wrong query values
I have a user who is using an access 2003 database to query a SQL server
through an ODBC connection. The table they are trying to hit has over a
million rows of data in it. When the query is run, it returns the correct
number of rows of data it should, but it is pulling the completely wrong
rows, however when the totals button is clicked (even though there is nothing
to total) and then t...
|
1 |
27.07.2006 18:26:02 |
|
|
Method 'Columns' of object 'IImexGrid' failed
I'm attempting to import an Excel spreadsheet into Access and am getting a
"Method 'Columns' of object 'IImexGrid' failed" message. What does it mean?...
|
2 |
27.07.2006 16:29:32 |
|
|
Import Excel SS Header Issue
I've got an Excel SS with a column header as Fin. Arr.
This denotes 1 column - not 2 separate columns.
In the TransferSpreadsheet macro, Access doesn't like the periods in the
column header. Is there anyway I can get Access to accomodate the header as
is? I don't really want to manually remove the periods before I import the
spreadsheet....
|
4 |
27.07.2006 16:04:25 |
|
|
Import DBF files with MEMO fields
I'm using MS Access 2002. I have to import data from DBF files everyday.
Every DBF files which has no MEMO fields will be imported succesfully, but
that won't happen for those DBF files which have a MEMO field. (In the past,
when I used MS Access 97, it's OK for all DBF files). To solve this, I have
to copy the DBF files that have MEMO field to other DBF files which have no
MEMO field, t...
|
11 |
27.07.2006 15:19:44 |
|
|
Access Import Wizard not able to select fields to imort
When using import Wizard to imort Excel spreadsheet, I'm not able to select
fields to skip. The fields option area doesn't seem to work....
|
5 |
27.07.2006 12:11:02 |
|
|
Automaticly naming a report exported to HTML?
I have a report that I use to export each row of my table to it's own HTML
page. What I need to do is use a name from each record in the table to name
the HTML.
...
|
1 |
27.07.2006 09:21:01 |
|
|
Export query to CSV
Hi,
I have two export questions:
1. What do i change in my query or table to allow me to export to 3
decimals. At the moment when i export the 3rd decimal gets cut off?
2. 1 field has the date in it and when i export it includes the time. how do
i take out the time and only export the date?
Thanks very much
George
...
|
4 |
27.07.2006 08:11:46 |
|
|
Keeping Word open to make changes
I am sending data from an access database using a function called by a macro
to send data from a form to a word document using bookmarks
The process works ok, but problem is after inserting data into document it
closes and returns to access and continues macro but i need to keep document
open to allow users to amend document then print it out and then return to
access and continue macro
...
|
2 |
27.07.2006 06:35:06 |
|
|
Import Error Reporting
I have several ASC File imports that occur through out the day. If the data
imported contains a mis-placed quote it will generat an ImportError table
that references the Record by row number of that has the problem.
Is there anyway to create an actual report for the user that is doing the
import that shows them the record(s) in question?
Thanks
Matt
--
Matt Campbell
mattc (at) saun...
|
2 |
27.07.2006 06:00:02 |
|
|
Importing Word Form data into Access
I'm trying to get data from a Word form (using form controls/bookmarks) using
the code from Sean Kavanaghs article from Dec 2001 (which has been discussed
in previous posts), but keep getting the following error
-2147217900: Invalid SQL statement; expected 'Delete', 'Insert',
'Procedure', 'select', or 'update'.
Here is the code:
Sub GetCRData()
Dim appWord As Word.Application
Di...
|
2 |
27.07.2006 01:52:01 |
|
|
Excel query to CSV
Hi,
I have two export questions:
1. What do i change in my query or table to allow me to export to 3
decimals. At the moment when i export the 3rd decimal gets cut off?
2. 1 field has the date in it and when i export it includes the time. how do
i take out the time and only export the date?
Thanks very much
George...
|
1 |
27.07.2006 00:03:02 |
|
|
changing properties in linked excel files
I have an Excel file I 've linked to a MS Access project. One of the columns
consist of letters and number combination (Ex DL1234) or just numbers (Ex
1234). When linked, MS Access automatically defaults this column information
to Number property and I am unable to modify this property. This causes
errors in the table as any number/letter combination is kicked out and is
replaced with...
|
3 |
26.07.2006 21:48:01 |
|
|
Dates to Excel bar graphs
Hi,
I have a table that has records with eight fields showing dates. Each couple
of these field values represents to a time period. To be more certain, they
show the start and end dates of the required tasks to accomplish a project.
I have tried to find a visual way to present it and I have thought to export
the table in an Excel spreadsheet that has date columns and shows the
requir...
|
2 |
26.07.2006 21:25:01 |