Search results

Hi, I am trying to import a CSV file with 287,000+ records into a SQL Server linked table. Using INSERT INTO takes a little over an hour. Someone had mentioned that there is a BULK INSERT that does the whole file at one time as apposed to one record at a time and should import a lot faster...

Hello, Is there a way to hardcode the From field when sending an email through VBA to Outlook? We are trying to have the Department name show up instead of the person sending the email. TIA

I have a table with a account number field that can have mixed data and I need to add leading zeros to anything shorter than 9 characters: 293613590 => 293613590 56908790 => 056908790 6128540590 => 6128540590 3600OLDC79 => 3600OLDC79 43OLDTO7 =>...

This might be difficult to explain, but I will do my best. I have a user form that has two date fields on it, [txtFromWeekly] and [txtToWeekly]. The user enters the two dates, clicks a button and it runs a query. In that query it reads the two fields using the following criteria...