DataBase - Help please
Asked By Dave
20-Nov-09 05:16 PM
have loaded about 97000 records its in the format below: All I need
is the following form the data :
City Name ------------------------------> Only Need the Name
of the city in this case COULDER
TAXABLE AMT ------------------------------> Only need the first
amount in this case 267.40
TAX AMT -------------------------------> Need the first 4
amounts in this case 12.03 1.34 10.70 0.00
I have Access 2003 what I would like if possible is to read this
massive text file and just extract the above information Every
Record
is divided by the CITY data item. the data is as below:
thanks in advance
CITY: COULDER COUNTY: SAFIRE GEOCODE: 37-011-0822 STR: COMPANY-CD:
0010 DIVISION-CD: CUST-CD:
EXEMPT CERTIFICATE #:
INV: 9002220111 DATE: 08/13/20005 LINE: 00020 PROD-
TAX RATE/TYPE----- .045000 S .005000
GROSS SALES------ 267.40 267.40
ZERO RATE AMT---- 0.00 0.00
TAXABLE AMT------ 267.40 267.40
TAX AMT---------- 12.03 1.34 10.70 0.00 24.07
Then The Next City Will come up and so on & on, what couould I do ? I
would appreciate it greatly if someone could do a macro on it.
thanks
Access 2003
(1)
City
(1)
Couould
(1)
COULDER
(1)
GEOCODE
(1)
005000
(1)
045000
(1)
SAFIRE
(1)
Steve Schapel replied to Dave
Dave,
You appear to have asked the same question multiple times.
--
Steve Schapel, Microsoft Access MVP
Roger Jennings on Access / Sharepoint DataBase http: / / www.quepublishing.com / articles / article.aspx?p = 1606238 I was very dismayed is it makes it pretty clear that in-house hosting of your Sharepoint server with Access Services to support browser-based Access apps is something only large companies will be able to afford, because the pricing and licensing for the Enterprise version is very, very steep. The alternative is hosted Sharepoint / Access Services, and the costs do not seem terribly high. It seems to me that the pricing is upside-down. Big enterprises do not want to deploy Access apps in the browser - - they will build their own .NET apps, browser-based or not 2010, it could vastly increase those costs for organizations with legacy hardware). The features of Access 2010 used in conjunction with Sharepoint 2010 seem to me to be most compelling for and small businesses. I do not know if I could sell clients on hosted Sharepoint / Access. I have been able to sell clients on hosted Exchange, and it is been very W. Fenton http: / / www.dfenton.com / contact via website only http: / / www.dfenton.com / DFA / Access Discussions SQL Express (1) SQL Server (1) MySQL (1) Exchange Server (1) Windows Server (1
Access 2010 for software development DataBase Hi, What do I need to use Access 2010 (or perhaps 2007) to port our 2003 application and create an executable (MDE in Access 2003)? Are there any issues with 2010? -paulw Access Discussions SQL Server (1) SharePoint (1) Albert D. Kallal (1) Office 2007 (1) Office 2003 (1) Access 2007 (1) Access 2010 (1) Access 2003 (1) You can use Access 2010 to develop
Access 2010 with Sharepoint 2010 DataBase I found this article http: / / sharepointproconnections.com / Articles / tabid / 149 to me was these two points: client." Hopefully this means you can test out the Access 2010 in a browser capabilities. 2.0 AA compliance. Level 1 browsers, which support 100 on other platforms. Level 2 browsers will have some limitations in rendering and behavior." Bob Access Discussions SQL Server (1) MySQL (1) Visual Basic for Applications (1) SharePoint (1) Access 2007 (1) Access 2010 (1) Office 2003 (1) Windows 7 (1) Well, the question is do you really need to go to now we build applications to the office standard (that might use outlook, excel, and MS access on the desktop), in the future we build applications that does all the similar functions figure out what is not going to work as well in the browser as in Access itself? Surely you are not claiming that 100% of an Access app is going to
Considerations migrating from Access 97 mdb to Access 2003 (or up)? DataBase What are the things I need to watch for? I know about sheet properties and Sandboxing mode and making sure to run Jet 4.0 SP8 for 2003 but what else should I look for? We're kind of at the end of the road (so it seems) with Access 97. It does not play well with Windows 7 Professional even in XP Mode, the is crashy / unsreponsive at times. I figure moving up to a more 'modern' version of Access can help alleviate some of these problems and allow it to run native in Windows XP mode. So I am all ears for recommendations on migration or ways to get Access 97 to work properly in Win 7. Thanks a bunch. Access Discussions Visual Studio .NET (1) Windows XP (1) Office 2007 (1) Access 2007 (1) Access
more confused I get. Looking forward to getting a new toy though! Cheers The Frog Access Discussions Larry Linson Microsoft Office Access MVP Co author Microsoft Access (1) James A. Fortune CDMAPoster (1) Visual Studio 2010 (1) Entity Framework (1) Microsoft Excel 1) Microsoft Word (1) Office 2010 (1) Access 2007 (1) No. There is a free Access 2007 / 2010 runtime you can download and distribute. Reuse. Still works. Mind you not for the web version of Access 2010 which only has macros. Tony - - Tony Toews, Microsoft Access MVP Tony's Main MS Access pages - http: / / www.granite.ab.ca / accsmstr.htm Tony's Microsoft Access Blog - http: / / msmvps