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 try
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 postgresql and just query
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 The name of the locale constant in the CreateDatabase
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, I am matching between the two tables based on each bonds’ “Loan
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