Hello I’m trying to import data from excel file (xls) to new SQL table so I use Import and Export data 32/bit to achieve that. When I load the excel file it automatically detects data types of columns. e.g. column with phone numbers is as data type to new table float and in excel is as Double(15) when I…
Tag: excel
How to run a SQL query on an Excel table?
I’m trying to create a sub-table from another table of all the last name fields sorted A-Z which have a phone number field that isn’t null. I could do this pretty easy with SQL, but I have no clue how to go about running a SQL query within Excel. I’m tempted to import the data into postgresq…
How can a blank MS Access database be created using VBA?
I’m a total noob trying to create a blank MS Access database using VBA in Excel. I want to name the new database “tblImport”. This is the code I´m using: I get the following error message: “Run Time Error 3001: Application Defined or Object Defined Error” What can I do? Answer Th…
Conversion failed when converting the varchar value ‘N’ to data type int
I have been finding original balances on bonds from an “Acquisition” table, for individual “performance” quarters. It has worked for every quarter, but when I attempted to run my query on 2010Q1, I received this notice: My query is: Zero balance code is telling how the bond defaulted, …
Formula to get date field in Excel sheet SQL Server query
I have data in Excel sheet and I need to update SQL Server DB table by using Excel sheet data, I am able to write SQL Server Query and get the data. However I am not getting date field in date format, it’s rendered as a normal number. Answer In cell B2 try this –
Excel 2003 send date parameters to SQL query
I have a few worksheets that use sql queries to retrieve data. I would like all of these sheets to query data based on the same date range entered by a user in excel. eg. I would enter somewhere in a form or in a cell a date range and retrieve the value in sql to obtain data based on