SQL sentence for make table

[aaron.kempf]

there is a known bug in DAO.

if you dipshits have been using DAO all along; and you still hope for
the day when MS starts taking it seriously; you are sadly mistaken

the heyday of ms access didn't even start until 2002-- with the new
release of Access Data Projects.

DAO isn't reliable enough for anything.

There is a known bug with using currentdb.execute
instead of dbs.execute

you can't refer to currentdb or else you risk having stability problems


-aaron

 

[aaron.kempf]

I import 5,000 records in less than 2 seconds; and this is an extremely
wide table

bulk insert is 10,000 times more scalable than anything present in mdb

-aaron

 

[aaron.kempf]

old habits might die hard

but it's been 6 years


no excuses and microsoft can **** their new DAO bullshit


simplify access; instead of having 9 different flavors.. you should
have one version that works correctly.

it is called 'access data projects'

 

[strive4peace]

Hi Tony,

thanks

Since we can't post attachments here, maybe I'll write a
little program to generate a data file to use in a new
thread -- and the problem may have been corrected in later
versions, too ... was just curious

Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day

remote programming and training
strive4peace2006 at yahoo.com

*

 

[Tony Toews]

I import 5,000 records in less than 2 seconds; and this is an extremely
wide table

bulk insert is 10,000 times more scalable than anything present in mdb

Reread my posting. It would be impossible to have any wizard or tool
import data with ten different record types in the CSV file.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[strive4peace]

you're welcome happy to help


Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day

remote programming and training
strive4peace2006 at yahoo.com

*

 

[aaron.kempf]

DAO is DED and you dipshits should crawl out of the 90s.

I mean seriously here.

Can DAO use shaped recordsets?

DAO can't even really connect to SQL Server well enough to do anything.

DAO isn't reliable enough.
Using CurrentDB.Execute; it doesn't even always raise an error when you
have a problem.

It is a known bug.

Stop clinging to the 80s; kids.

DAO is DEAD.

-Aaron

 

[aaron.kempf]

RE-READ MY POSTING

your crappy bullshit way of doing things?
you should stop reccomending obsolete ways to work.

OH WE SHOULD ALL BUILD A BRAND NEW MODEL T FORD HUH??

diptard; shit

yeah; i could import all of it as a single table; and then parse it out
based on placement of characters.

Import it all into SQL and then do 10 scans on it.

big deal; I could do this with my hands tied behind by back.

select *
into TallTable
from openRecordset(kjsdhkjshdfkjshf, dasflkjsdkjsldf)

Select *
Into ShortTable1

From TallTable Where TallTable.Col1 LIKE '-- ## %% $$ '

Select *
Into ShortTable2

From TallTable Where TallTable.Col1 LIKE ' __ ## ## ####,## '

Select *
Into ShortTable3

From TallTable Where TallTable.Col1 LIKE '-- ## %% $$ '

Do you get the idea?

A whole new world of opportunity awaits you if you lose your training
wheels.

get this; you can run multiple SQL statements in a row without writing
CODE

ohhh,, ahhhhhhh, ohhhhh, ahhhhhhhhhhhhh

time to lose the training wheels kids.

worse comes to worst; you might need to write a schema.ini file.. not
rocket science.

the best part is that it wouldn't take 10 pages of vba code to do it.
if you can do anything in SQL only you should do it in SQL


-Aaron