Search results

I have a new blog up about clsMsgPD which is a predefined or predeclared class which I use to pass messages around. In this case a client asked me to create a "big edit" form. The user could dbl-click into any text box following a naming convention and doing so would open a form with a single...

I think this is a geo database, not the one I was trying to import.

Welcome @chgeiselmann. A lot of us started as self taught, myself included. Many of us continue that way. This board is a great resource for real world experience from helpful folks.

:)

The file is a 36gb download for the text download. I can't just append it to a message here. And that is zipped.:eek:

@Gasman How can I PM you?

It took me hours to download, although my internet down speed isn't particularly speedy.

https://www.transportation.gov/gis/national-address-database

BCP was unable to handle the very common field data like Peoria,,,"Country Meadows Units 5, 6, & 7",,,,,,AZ, With field delimiters of "" and inside that comma delimited strings. Failed to import every record with such data and there were a ton of them. So BCP kinda worked but not well...

Having done that I successfully pulled in several million records out of (apparently) somewhere around 60 million addresses. I got some dat from around 20 states, many just a few thousand records. Some states with tens or hundreds of thousands of records. My guess is that those states were...

What I don't have is it imported into SQ Server! To use BCP I had to go into the ini and manually copy the ini field lengths into the BCP field mapping thingie. Thingie is a very scientific term I picked up somewhere. :ROFLMAO:

I have a schema.ini

I have an xml file

I have a text file. It appears to be a csv file.

What is this? And how do I use it?

IIRC it is a 36 gb file. Compressed. However I might have it in a usable format already. Do you know what GDB files are?

I know for a fact that the data heavily used "" around commas in long strings. From my reading BCP does not have a switch to tell it to ignore that. I managed to pull in about 3.6 million records by telling BCP to use a batch of 10K (write every 10K) and ignore a million errors. It was...

Sometimes it is important to know stuff just because. If you ever want to insert records to "fill in a hole", recover archived records etc, you probably want to run another query that finds the highest PKID, increments by one, and inserts that record as well. This allows the autonumber to...

In #62 I said that it would do this except that I thought the PK mechanism was smart enough to go find the last PK value and increment that. IOW I thought when I entered I: 5 it would know it was "out of room" and go find the highest PK... 6, increment that, and start with 7. Instead it tried...

I used George's little demo to run his query, inserting the PK number 2. I then entered G and H successfully. Notice that the PK continued to increment the counter from 2 - G: 3, H: 4 However when I tried to enter I : 5, it stopped me from entering that record because the autonumber was trying...