Search results for query: *

I'm trying to split a table into multiple tables. The code I'm using is the following but I keep getting a syntax error in querey expression. SELECT [2004 Retail].NAIC, [2004 Retail].[ZIP Code], [2004 Retail].[Total Establishments], [2004 Retail].[1-4], [2004 Retail].[5-9], [2004...

I have the following macro in excel.. Sub replace() ' ' replace Macro ' Macro recorded 6/18/2007 by LISC USER ' Range("B1:CM4000").Select Selection.replace What:="** ", Replacement:="", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _...

I have a table where I need to replace all the fileds that contain "**" with nothing, and one containging *##(# acually representing 2 numbers) with just ##. The issue I run into is that the * selects all the fields and characters, is there away to disable that feature or something along those...

I have information for the 50 states split by zip codes and in 50 different tables. I want to combine them all into one table but can't seem to get it to work. I get an error.....8114 error converting data type nvarchar to float. Heres the code.. Insert into All_States Select * from [AL IRS] GO...

I have 51 tables(all 50 states plus DC), all with identical fields. I want to create a table that combines them all into one table but can't seem to figure it out. Heres is a test code that I tried to run but get an error "too many fields" INSERT INTO [IRS '98] SELECT a.ZipCode1998...