|
|
 |
Re: FN-FORUM: Database Converion MS Access to MySQL
date posted 21st March 2003 19:13
Well in that case is something they exported from access to a .dat format I
never heard about.
I have already tried in 1000 different way to import the file into access,
and I always get the message: " Unrecognised Database format".
If I open the file with notepad, I get something like that (only the first
10 lines of the huge file will follow):
Df D D{ D
D‡ D< D� €( D¸ DÃ DT D· D D†D DÑ DU DW D´ D¼ D„ DŽ
DT D D® D DÃ D DÉ D†DS D Dl €Ô D² Dž D¨ D> D. D½ Dd
D D$ D� Dù D D D DS DÊ DÌ Dœ Dæ Dì DÕ Dq DE Do D €-
� DC D£ D‹ DR DÇ Dó Dt Dv Dà DÞ D0 D¹ € S1985 DAINO
V15 SEMPLICE MT DG05
E1 020004800040363001 011
�ÌÌÌÌÌ@
0 0 100 0
00 ð? ÿÿÿÿÿÿÿÿ
D € 0STARSTLLYC STAR:STAMPA LYCRA SENZA OPAC
MT 020004800980363001 011
¤p=
×£@
0 0 100 0
00 ð? ÿÿÿÿÿÿÿÿ
D5 ‚ƒ‚ 1119 NASTRO GOMM.NYLON NERO MT.50
CM WW03 C9 020004800020360002 011Ã¥
NYLON NORMALE \ AñcÌç?
³|1 \ AñcÌç?³|1›Z_iÌç? @[EMAIL REMOVED]@ ®Gáz®ç?
0 0 100 0
00 ð? ‡ ÿÿÿÿ è
D-€. GR1264 JERSEY SEMPLICE
MT JJ07 B0 020004800210360014 011/ /
. JERSEY 120 GR JERSEY 120(BERTJERSEY 80
)\�Âõ(ä?×£p=
×ã?(
ô‰Iã?ç}1¤p=
[EMAIL REMOVED]@ ¤p=
×£à ?
0 0 100 0
00 ð? ÿÿÿÿÿÿÿÿ
the last 3 lines as you can see, look like a table data too me, what you
think? the file goes on and on like that for a lot.
maybe they use a plug-in to save the file in that format, that is my 2 cent
thought.
Kind Regards
-------------------
Gualtiero Tabacchi
Puzzle Solutions ltd.
www.gualtiero.co.uk
----- Original Message -----
From: "Pete Croft" [EMAIL REMOVED]
To: [EMAIL REMOVED]
Sent: Friday, March 21, 2003 6:57 PM
Subject: Re: FN-FORUM: Database Converion MS Access to MySQL
> > Hi Genius,
> > I'm having a bit of a problem with a database conversion.
> ...
> > Now My problem is that the file I got from my client is a .dat file, so
I
> > suspect hey are using some sort of plug-in for access that export this
kind
> > of file; the client also assure me that is not possible to save a file
in
> > .mdb from his MS access.
>
> IME (Access 2 - 2000) native Access files are always .mdb (unless
> they're .mde) so I think your client is somewhat confused.
>
> That said, the file extension doesn't actually matter - if you take a
> normal Access MDB and change the extension to DAT it will still open
> and run OK, as long as you explicitly tell Access to open it. So, it's
> just possible that someone has done that to try and disguise the fact
> that it's an Access file. Somehow I doubt it, however; it's more
> likely that the DAT file isn't an Access file at all, or is a
> compressed/attachment file and the Access file is inside it.
>
> Cheers,
>
> Pete
>
> --
> Peter Croft
> PC Associates
>
>
> ==========
> |
|
|
