Access Database on Linux
Ray Parrish
crp at cmc.net
Wed Nov 26 04:23:29 UTC 2008
Chris Mohler wrote:
> On Wed, Nov 26, 2008 at 8:37 PM, Ray Parrish <crp at cmc.net> wrote:
>
>> Hello,
>>
>> My web hosting is unfortunately on a Windows server, so I am restricted
>> to the use of the Access Database and Active Server pages.
>>
>> Is there any program which can create an Access Database on Ubuntu?
>>
>
> I don't remember exactly what Access can import (CSV, .dbf?), but you could try:
>
> 1. Create DB and table(s) in Openoffice Base.
> 2. Right-click a table in Base and select "copy".
> 3. Open a new OpenOffice Calc spreadsheed and paste.
> 4. Export/Save As the table in a format that Access can import.
>
> Obviously, this is going to suck big-time if you have more than a few
> tables, and don't ask me why there's no File->Export in Base. As for
> the ASP problem I can only wish you luck ;)
>
> Chris
>
> PS - you can get a Linux hosting account on the cheap these days :)
>
>
Hello again,
Thanks for the tip, however I have no Access Database program to import
the resulting exported file. The program, I guess, resides on the
server, and I have no way to use it without first creating a database
to access. I can add to an existing database with ASP once one is on the
server,, but it's a chicken or the egg situation without first having
one to write to.
I can get Linux hosting at my current web host, but it involves
switching packages, and if I do that I lose my perk of free domain name
registration for the life of my current package. Since I'm a poor boy, I
want to keep those domain names free. 8-)
I've been studying the ASP tutorials on the W3C Schools web site and it
doesn't look too difficult to me. I can even use Javascript to create
.asp pages, if I want to avoid learning VBScript, but I used to program
in Visual Basic so VBScript shouldn't be too hard for me.
Later, Ray Parrish
--
http://www.rayslinks.com/ Web index of human reviewed links.
<http://www.rayslinks.com/Troubleshooting%20and%20fixing%20Windows.html>
Trouble shooting and Fixing Windows
http://www.writingsoftheschizophrenic.com My poetry in web pages
More information about the ubuntu-users
mailing list