I have a table that I create using a query (sql below) that I need to be able
to import a text file into. When I manually do the import into a new table
on the fly everything works fine. When I try to append to the table I
created beforehand the geocode number fields get truncated and don't import
correctly. I would like to be able to automate this task as much as possible
using create table and drop table so that I do not have to babysist the
process. Please help me.

Here is all the information:

TEXT FILE FORMAT:
38.709601,-121.339298,1234 anywhere,yourcity,yourstate,11111

TABLE FORMAT:
CREATE TABLE tblGeocoded (GeoCodeID COUNTER CONSTRAINT PrimaryKey PRIMARY
KEY, Latitude LONG, Longitude LONG, Address TEXT, City TEXT, State TEXT, Zip
LONG) NOTE: Zip imports just fine.


I could really use your help here. Thanks in advance.

....Dana

Dana,

Try using a Double instead of a Long for Longitude and Latitude. As for Zip
I always use text as it can start with a zero and *real* numbers do not
start with zero.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Dana F. Brewer" <(E-Mail Removed)> wrote in message
news:A36A3FCD-39CB-42F3-8800-(E-Mail Removed)...
>I have a table that I create using a query (sql below) that I need to be
>able
> to import a text file into. When I manually do the import into a new
> table
> on the fly everything works fine. When I try to append to the table I
> created beforehand the geocode number fields get truncated and don't
> import
> correctly. I would like to be able to automate this task as much as
> possible
> using create table and drop table so that I do not have to babysist the
> process. Please help me.
>
> Here is all the information:
>
> TEXT FILE FORMAT:
> 38.709601,-121.339298,1234 anywhere,yourcity,yourstate,11111
>
> TABLE FORMAT:
> CREATE TABLE tblGeocoded (GeoCodeID COUNTER CONSTRAINT PrimaryKey PRIMARY
> KEY, Latitude LONG, Longitude LONG, Address TEXT, City TEXT, State TEXT,
> Zip
> LONG) NOTE: Zip imports just fine.
>
>
> I could really use your help here. Thanks in advance.
>
> ...Dana
>

Hi Gina. I should have said that I have tried double, long, etc. I resolved
the problem myself by creating an input spec and changing the . in Decimal to
another character so the process wouldn't get tripped up on the "." in the
numbers.

Thanks anyway.

"Gina Whipp" wrote:

> Dana,
>
> Try using a Double instead of a Long for Longitude and Latitude. As for Zip
> I always use text as it can start with a zero and *real* numbers do not
> start with zero.
>
> --
> Gina Whipp
> 2010 Microsoft MVP (Access)
>
> "I feel I have been denied critical, need to know, information!" - Tremors
> II
>
> http://www.regina-whipp.com/index_files/TipList.htm
>
> "Dana F. Brewer" <(E-Mail Removed)> wrote in message
> news:A36A3FCD-39CB-42F3-8800-(E-Mail Removed)...
> >I have a table that I create using a query (sql below) that I need to be
> >able
> > to import a text file into. When I manually do the import into a new
> > table
> > on the fly everything works fine. When I try to append to the table I
> > created beforehand the geocode number fields get truncated and don't
> > import
> > correctly. I would like to be able to automate this task as much as
> > possible
> > using create table and drop table so that I do not have to babysist the
> > process. Please help me.
> >
> > Here is all the information:
> >
> > TEXT FILE FORMAT:
> > 38.709601,-121.339298,1234 anywhere,yourcity,yourstate,11111
> >
> > TABLE FORMAT:
> > CREATE TABLE tblGeocoded (GeoCodeID COUNTER CONSTRAINT PrimaryKey PRIMARY
> > KEY, Latitude LONG, Longitude LONG, Address TEXT, City TEXT, State TEXT,
> > Zip
> > LONG) NOTE: Zip imports just fine.
> >
> >
> > I could really use your help here. Thanks in advance.
> >
> > ...Dana
> >
>
>
> .
>

Dana,

As long as you got solved then that is all that counts...

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Dana F. Brewer" <(E-Mail Removed)> wrote in message
news:39B90EBE-FC1B-479B-8963-(E-Mail Removed)...
> Hi Gina. I should have said that I have tried double, long, etc. I
> resolved
> the problem myself by creating an input spec and changing the . in Decimal
> to
> another character so the process wouldn't get tripped up on the "." in the
> numbers.
>
> Thanks anyway.
>
> "Gina Whipp" wrote:
>
>> Dana,
>>
>> Try using a Double instead of a Long for Longitude and Latitude. As for
>> Zip
>> I always use text as it can start with a zero and *real* numbers do not
>> start with zero.
>>
>> --
>> Gina Whipp
>> 2010 Microsoft MVP (Access)
>>
>> "I feel I have been denied critical, need to know, information!" -
>> Tremors
>> II
>>
>> http://www.regina-whipp.com/index_files/TipList.htm
>>
>> "Dana F. Brewer" <(E-Mail Removed)> wrote in message
>> news:A36A3FCD-39CB-42F3-8800-(E-Mail Removed)...
>> >I have a table that I create using a query (sql below) that I need to be
>> >able
>> > to import a text file into. When I manually do the import into a new
>> > table
>> > on the fly everything works fine. When I try to append to the table I
>> > created beforehand the geocode number fields get truncated and don't
>> > import
>> > correctly. I would like to be able to automate this task as much as
>> > possible
>> > using create table and drop table so that I do not have to babysist the
>> > process. Please help me.
>> >
>> > Here is all the information:
>> >
>> > TEXT FILE FORMAT:
>> > 38.709601,-121.339298,1234 anywhere,yourcity,yourstate,11111
>> >
>> > TABLE FORMAT:
>> > CREATE TABLE tblGeocoded (GeoCodeID COUNTER CONSTRAINT PrimaryKey
>> > PRIMARY
>> > KEY, Latitude LONG, Longitude LONG, Address TEXT, City TEXT, State
>> > TEXT,
>> > Zip
>> > LONG) NOTE: Zip imports just fine.
>> >
>> >
>> > I could really use your help here. Thanks in advance.
>> >
>> > ...Dana
>> >
>>
>>
>> .
>>