Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 10th 05, 05:40 PM
Night Owl
 
Posts: n/a
Default Formatting of Data from .CSV file

Hi,
I've got a database that exports data to a CSV file that I would like to
import into an Excel spreadsheet, which I can do, but there are one or two
anomalies in that the data is in text format rather than numbers, which I
need to resolve.

For example, a date string is exported in the format
"2004-04-01-03.29.00.000000" which I would like to extract into separate
date (dd/mm/yyyy) and time (hh:mm:ss) fields.

Also, the same spreadsheet has an address field, with underscores as
separators. Is the a (simple) method that can be used to strip out spurious
text (e.g. specific symbols), insert a comma and space, then reformat the
text to sentence case rather than a mixup of upper and lower case.
Obviously (?) the addresses are nearly all different, but the reason I want
to do this is to count the number of times an address occurs in the
database.

Would it better to run an import macro into the spreadsheet to append the
data (approximately 25-50 records a week on top of an existing database of
some 25000 records) or should I import the data directly into Access and
format it from there?

Any help would be appreciated.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Getting data from another excel file Union70 Excel Discussion (Misc queries) 0 May 2nd 05 02:17 PM
Line Graph Data Recognition Nat Charts and Charting in Excel 2 April 30th 05 02:07 PM
Retain PivotTable formatting after "Refresh Data" Joel 48371 Excel Discussion (Misc queries) 1 April 1st 05 09:48 PM
File Error: Data May Have Been Lost Tbird2340 Excel Discussion (Misc queries) 8 March 20th 05 05:31 PM
insert data from one excel file into another Leonard Excel Discussion (Misc queries) 1 December 2nd 04 12:35 PM


All times are GMT +1. The time now is 07:07 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017