by taav » Sat, 19 Apr 2003 19:01:59
by Paul Whit » Sat, 19 Apr 2003 21:01:34
You should be able to open the dBase files in Excel, then save as a CSV.Quote:> how convenient is it in real to transport data from old dbase (almost 20
> years old) database, ms access and ms excel to a new database, probably
> somekind sql db? what are the biggest problems? and what are the best ways
> to do this?
Same with the Excel files, open them and save as CSV.
Access tables can also be saved externally as CSV files.
Then import them into your new SQL database one at a time.
by taav » Sun, 20 Apr 2003 19:09:25
and probably there will not be big problems while creating CSV files fromQuote:> You should be able to open the dBase files in Excel, then save as a CSV.
> Same with the Excel files, open them and save as CSV.
> Access tables can also be saved externally as CSV files.
> Then import them into your new SQL database one at a time.
by Paul Whit » Sun, 20 Apr 2003 22:51:19
Don't know, never tried.Quote:> and probably there will not be big problems while creating CSV files from
> MySQL database??
by Alan » Wed, 23 Apr 2003 22:11:50
Quote:> how convenient is it in real to transport data from old dbase (almost 20
> years old) database, ms access and ms excel to a new database, probably
> somekind sql db? what are the biggest problems? and what are the best ways
> to do this?
1. Problem Access->Excel->Access
first try...
Hi I'm having a smaller :-(( problem with my MS Access dB.
Im writing a reliability performance follow-up database
for a customer. The database collect performance data
from field use and calculates peformance values on a report.
The problem is best described by an example.
1.The calculated performance data is stored in a single table.
2.The table is exported (by code) to MS Excel.
3.In Excel the data makes four predefined 'quite advanced' graphs.
4.The graphs are then transferd back to a report in Access as
OLE-objects.
All communication between Access and Excel is hided for the user.
I think that it is step four that isn't working properly, because
when I'm opening the report in my Access application it works fine the
first
five or six times. But suddenly, when I'm open the report, something
happens.
The program freaks out and I'm getting error messages something like
-VBA libraries not..... and Timer not installed etc.
Sometimes it works again if I restart windows but mostly I have to
reinstall the
reg-files and even reboot.?????? Very user friendly, don't you think !
PLEASE HELP ME !!
This is the only thing left to do with the application before delivery.
Do you have any ideas or experience in this type of errors don't
hesitate
to answer. I will be very grateful for any kind of help.
One alternative will be to only perform 1..3 and print out the report
from
Excel but that is to let MS Access win :-(.
Greatings
Niklas Barkman
Enator Communications AB, Sweden
2. Dealing with IP addresses in a SQL Database
3. How to transfer data from SQL server to excel/text/access/dbase using VB and ADO
4. License Installation problem on Linux
6. SQL Server - records locking up for no reason
8. Table designer differences SQL Svr 2000 vs SQL Svr 7
9. DTS problem SQL7->DTS->Excel->DTS->SQL7
10. Microsoft Excel WorkSheet -> dBase table
11. Microsoft Access or Microsoft Excel >>>>>> Oracle PRO
12. Help: Excel->(Client)->PC-NFS->Unix DBMS Server