Leading zeros in csv files

[Guest]

I have a .csv file that I am bringing into Frontpage as a data source. When the page populates, it seems that any number that has a leading zero returns a blank field, otherwise if the number starts with anything other than zero, like a number or letter, than the field populates correctly with that number

Anyone have a suggestion on how I can make Frontpage return all values correctly

Thanks

Taz

 

[Thomas A. Rowe]

Import the csv data into Access and then make the field a text field.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

I have a .csv file that I am bringing into Frontpage as a data source. When the page populates, it

seems that any number that has a leading zero returns a blank field, otherwise if the number starts
with anything other than zero, like a number or letter, than the field populates correctly with that
number.

 

[Guest]

I've actually already done that and it does indeed work. However, I would still like to try and get it to work straight from the csv files because these are files that come out on a regular basis every other day. So once I have my webpages set all I need to do is drop the new csv's into the correct location and I have the new, updated data. Thanks for the suggestion

Ta

----- Thomas A. Rowe wrote: ----

Import the csv data into Access and then make the field a text field

--
=============================================
Thomas A. Rowe (Microsoft MVP - FrontPage
WEBMASTER Resources(tm
http://www.ycoln-resources.co
FrontPage Resources, WebCircle, MS KB Quick Links, etc
=============================================
To assist you in getting the best answers for FrontPage support see
http://www.net-sites.com/sitebuilder/newsgroups.as

I have a .csv file that I am bringing into Frontpage as a data source. When the page populates, i

seems that any number that has a leading zero returns a blank field, otherwise if the number start
with anything other than zero, like a number or letter, than the field populates correctly with tha
number

 

[Thomas A. Rowe]

The problem is that .csv is a text file, however it is open like a Excel file which set the field
with numbers to the number format which then drop all leading zero. Because it is a text file, there
is no way to control the field type.

The best I think you can do, is to import it into Access each day and then upload the Access
database.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

I've actually already done that and it does indeed work. However, I would still like to try and

get it to work straight from the csv files because these are files that come out on a regular basis
every other day. So once I have my webpages set all I need to do is drop the new csv's into the
correct location and I have the new, updated data. Thanks for the suggestion!

 

[Guest]

Do you know if there is a way to automate the import into Access? I'm not really against that idea if I can automate as I am using about 20 different csv files

Also, one other thing I tried in Access is linking to the csv files. When doing that I could open them in Access just fine but if I tried to use any of the linked tables in Frontpage it errored out with an ODBC error of some sorts

Do you know if it is possible to use linked tables (that point to files outside Access) in Frontpage

Taz

 

[Thomas A. Rowe]

I would suggest posting your first question to the Access newsgroup. In general you will only want
to use the single Access file in your FP web.
--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

Do you know if there is a way to automate the import into Access? I'm not really against that idea

if I can automate as I am using about 20 different csv files.

Also, one other thing I tried in Access is linking to the csv files. When doing that I could open

them in Access just fine but if I tried to use any of the linked tables in Frontpage it errored out
with an ODBC error of some sorts.