Dave,
Thanks for your response. The problem with that, while it is technically one
insert statement, mySQL still builds the primary key record-by-record
(keycache), rather than sorting the keys and creating the index in one shot,
like myisamshk can do. "INSERT..." would take upwards of 24 ho
Hank
Instead of dropping down to OS cp commands, insert the data from
table TBL_FLAT to TBL_INDX.
INSERT INTO TBL_INDX SELECT * FROM TBL_FLAT;
This will be valid in mysql. The insert will be fast since
only one insert statement. Let the list know if this works
for you. Or if your method is val
sday, September 18, 2001 11:30 AM
To: [EMAIL PROTECTED]
Subject: Re: Question about converting
Troy,
If you cannot connect to it, how do you use?
Christopher Reed
Application Analyst
Information Technology
City of Lubbock
[EMAIL PROTECTED]
>>> "Troy Montour" <[EMAIL PROT
OTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, September 17, 2001 5:09 PM
Subject: Re: Question about converting
Troy,
Have you considered MyODBC? Access works well with linked ODBC tables.
Then, within Access, you can copy the linked table into an Access table.
Hope this helps!
C
mySQl-to-Access 1.1 works great but it's not free. The trial version only
converts 5 records.
It's at http://www.convert-in.com/demos/sql2accd.exe
Chris
- Original Message -
From: "Troy Montour" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, September 17, 2001 22:56
Subject: Q
-
From: "Christopher Reed" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, September 17, 2001 5:09 PM
Subject: Re: Question about converting
Troy,
Have you considered MyODBC? Access works well with linked ODBC tables.
Then, within Access, you can copy the l
Troy,
Have you considered MyODBC? Access works well with linked ODBC tables. Then, within
Access, you can copy the linked table into an Access table.
Hope this helps!
Christopher Reed
Application Analyst
Information Technology
City of Lubbock
[EMAIL PROTECTED]
>>> "Troy Montour" <[EMAIL PRO