|
Importing excel lists into the contacts template
I dwonloaded the contacts template and now I want to bring in a contact list
I have in Excel. I keep getting an error message when I click "finish" on
the wizard. What is the porblem?...
|
4 |
19.06.2006 23:03:31 |
|
|
export CSV from Access with zero padded fields
--
Dave...
|
2 |
19.06.2006 21:24:31 |
|
|
link to sage line 50
Hi All,
I have a possible project coming up where I need to connect to SAGE line 50.
As I have never done this could someone out there possibly advise me on the
ins and outs of doing it. to me it seems like all I need to do is provide a
ODBC link to the tables in it, but as experience has taught me, it is nevr
that simple.
Any links to white papers or articals would be much appriciat...
|
2 |
19.06.2006 21:21:42 |
|
|
Import table from MsWord
Hello:
I would like to find out how to How to Export a Word Table to Access
Database or Spreadsheet Application.
I read an article about layout converter. I don't seem to have this
converter available. Text format is not read as rows and columns and for each
new value a new field is created.
Can you help?
--
danka
--
danka...
|
4 |
19.06.2006 21:19:52 |
|
|
Counting records imported with the Transfertext method
Background: Weekly we import information into a table from a text file via
the Transfertext method.
Problem: I wish to obtain through code the number of records sucessfully
imported from the text file, but cant seem to find that option in the help
for the transfertext method.
I know I can just count the records in the table I am importing into before
then subtract the after diffe...
|
4 |
19.06.2006 16:37:01 |
|
|
Delete all blank records
I have an Excel spreadsheet that I transfer into a database each week. The
range that contains data always varies (it is over written each week by
another department.) so it would not be practical to specify the range to
import in Access or delete the rows Excel sees even thoughthey don't contain
data.
Is it possible to record perhaps an update query that will delete all blank
record...
|
2 |
19.06.2006 16:04:02 |
|
|
Check to see if updated first
Right now, I'm using a macro to automatically import a spreadsheet. Before I
can do that, I have to go out and see if the previous department has updated
that spreadsheet. If not, I come back to check again later.
Can Access check to see if the spreadsheet has been updated today, if so
import if not tray again in a specified amount of time?
...
|
2 |
19.06.2006 16:01:02 |
|
|
Create a CSV output file padded with leading zeros from Access?
--
Dave...
|
1 |
19.06.2006 14:36:03 |
|
|
ado, access & sql server
two tables hosted on a sqlserver database, with linked table. one table
have a foreign key on the field "sendmode"
if i try to update a record with a bad value on the field, access reports a
runtime error. It's fine but i have only one message "odbc call failed".
I would like to have the 2nd message (the why message) but access report
only one message.
do you have an idea to have the s...
|
1 |
19.06.2006 13:55:22 |
|
|
Append more than two imported tables
Thank you in advance
I need to append more than two tables and I found the instruction on how to
do it online however is not working.
Would you please send me the instructions on how to append more than two
tables?
Thank you
...
|
1 |
19.06.2006 13:07:02 |
|
|
Can I import from ULTRAPLS?
A co-worker has a relatively old (1989?) but valuable database, the data and
structure of which I want to have accessible to/convert to Access. I keep
getting error messages that say that the ULTRAPLS is an "unexpected" format.
I have installed ULTRAPLS.EXE and several databases in this format, and they
operate just fine on their own (independent of Access). I've tried "Open
With..." ...
|
3 |
19.06.2006 12:03:02 |
|
|
exporting to access tables to excel ready template
Hi
I have access data which i download in excel and i then copy the downloaded
data in another excel readymade template to present to my customer.
Is their any program or any easy way which will solve my problem of copy the
data to the template.
...
|
1 |
19.06.2006 10:12:02 |
|
|
how to link access data access page to file or excel
Hi
Any help here would be appriciated, thanks
Basically i wish to create a event's calender as an excel spreadsheet, i
would then like to link this to an access database so that when you clicked
on a event and it would take you through (by hyperlink) to a form page on
access with the event details. this would mean the calender would be easy to
navigate on excel but would be benefi...
|
1 |
19.06.2006 09:29:01 |
|
|
Linking Excel Spreadsheet
Hello,
I've inherited an MS-Excel 97 spreadsheet, as a data-entry sheet. I need to
import & link the spreadsheet into an MS-Access 97 database.
I need to keep the spreadsheet as a "data-entry" sheet, because of the mass
amount of data it contains, & the number of people using the spreadsheet.
1. How can I link the spreadsheet to an MS-Access 97 database?
2. Is it possible to convert the sp...
|
1 |
18.06.2006 21:40:44 |
|
|
Requerying a MySQL database via an ODBC DSN
Hello all,
I imported external data via an ODBC database with no problems. Access is
displaying the data fine, but I am now trying to refresh the data (or rather
requery the database) to show newly added/deleted records but nothing's
happening.
I was first doing a Records -> Refresh, but that didn't work, so a little
bit of searching showed that I should requery with Shift + F9, b...
|
1 |
17.06.2006 18:44:01 |
|
|
Link to a SyBase database
Anyone can help me with a driver to link to a syBase database?
Thanx!...
|
1 |
17.06.2006 14:39:01 |
|
|
Opening and Saving Access 97 files in Access XP
Basically as a school project I have to do a database. At school we are using
Access 97. At home I have Access XP. Now you cant open Access XP Databases in
97. But you can open 97 files in the XP version. But you cannot save them as
97 files once youv'e finished with it (I hope everyone is still following
here). I was wondering if there was a way that you could save 97 files in XP
as 97 ...
|
3 |
17.06.2006 13:56:02 |
|
|
TransferText command
At the end of processing I export out a fixed length record using a query.
There are nine different queries that I run.
Sometimes the text file is created and sometimes not. It appears the problem
is that one query isn't finished before the next one starts. I have tried
putting a for loop with a count to slow things down but that also is hit or
miss.
Below is the code that I am using...
|
4 |
17.06.2006 05:39:12 |
|
|
Importing text files to another database
It's possible do Import text files to another database directly?
I'm working with front end and I want to call the TransferText to
import the file to the back end database. Or I must to import to the
front end and then transfer the table to the back end and after that
delete the table in the front end?
[]'s
BD...
|
1 |
16.06.2006 23:30:42 |
|
|
import text file errors - cutting off decimals
Hi,
I am trying to write a macro that uploads a csv file.
Field 7 is a price e.g 1.6500 but Access is cutting off the decimals giving
1 in field 7 of the table and not the complete 1.65. Can somebody help?
Thanks
George...
|
7 |
16.06.2006 19:05:24 |
|
|
How do I link/export an address from Access into Word document?
Streamlining paperwork preparation for a small law office that generates two
kinds of word documents: those that go to clients via snailmail and those
that get put into Adobe Acrobat to send to court electronically.
Current dBase III database will get put into Access 2003. Goal is to reduce
retyping of info such as addresses. The letters that go to clients will stay
in Access, but the ...
|
2 |
16.06.2006 17:39:45 |
|
|
Linking Visual Foxpro tables to Access 2003
I have been trying to download a Visual Foxpro driver to help read Visual
Foxpro tables in Access. I have downloaded the Microsoft OLE DB Provider for
Visual Foxpro 9.0 SP1 from the downloads section in Microsoft.
When I go into Control Panel/Administration Tools/Data Sources to add the
driver, I get the message "You must install the current version of Visual
Foxpro ODBC driver".
Am I do...
|
2 |
16.06.2006 14:36:18 |
|
|
What do you do with extra quotes when importing a csv file?
We receive a parsed csv file that I import into a access table. I have 2
records that won't import because that parsed file has a field with extra
quotes, like some of the words in a field have quotes around them. If you
open it in excel, it works fine, you just lose the quotes. But access just
throws those records into an error table.
I have no clue as to how to get around this. An...
|
3 |
15.06.2006 18:07:02 |
|
|
Asset Database
I am working in an asset database. When I dispose of assets I want it to
pre-load information into Excel spreadsheet and then go back and update the
record in access to say disposal submitted. Can anyone help?
...
|
2 |
15.06.2006 17:51:00 |
|
|
How do I import data from multiple Excel Files into Access at one.
We save the same excel file with production data with names that describe the
production run. We could have up to 20 files a day and I would like to
import all of these files into Access in a simpler way. Any Ideas?...
|
2 |
15.06.2006 17:48:51 |